Removes values or members in one list from another list.
@REMOVE (list1, list2)
A list of member specifications, from which the members specified in list2 are removed.
A list of member specifications to be removed from list1.
In the Sample Basic database,
returns Massachusetts, Florida, New Hampshire.
The following example is based on the Sample Basic database. Assume that the Market dimension contains an additional member, Non-West.
A special analysis requires a sum of the actual sales values of a particular product family for non-western states. In this example, the @REMOVE function is used with the @SUMRANGE function to perform this analysis. The @LIST function is used to group the last two arguments of the @REMOVE function (the children of West plus two additional members, Texas and New Mexico).
FIX(Sales) "Non-West"=@SUMRANGE(Sales,@REMOVE(@LEVMBRS(Market,0), @LIST(@CHILDREN(West),Texas,"New Mexico"))); ENDFIX
This example produces the following report:
Jan Colas Actual Sales ===== Non-West 5114 New York 678 Massachusetts 494 Florida 410 Connecticut 310 New Hampshire 213 East 2105 California 941 Oregon 450 Washington 320 Utah 490 Nevada 138 West 2339 Texas 642 Oklahoma 180 Louisiana 166 New Mexico 219 South 1207 Illinois 579 Ohio 430 Wisconsin 490 Missouri 360 Iowa 161 Colorado 643 Central 2663