Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with n data as columns.
One of the data is called [System_Type]. [System_Type] has the following:
System A INSTALL
System A REMOVAL
System B INSTALL
System B REMOVAL
New System
Old System
REMOVAL System
In the set expression for this data, it is currently =[System_Type].
How can I explicitly exclude selection that has "REMOVAL"? That is, the straight table should not have "REMOVAL" available to the user to select at the column magnifying glass.
I saw some forum posts using E, but I can't get it to work. I know how to filter the selection (but NOT EXCLUDE) if I use Aggr+Only, so what is the reverse to apply EXCLUDE instead?
Thanks.
Hi
You can use the implicit exclusion operator or the element function E() as such.
=Sum({<[System_Type]-={"*REMOVAL*"}>} Amount)
Or
=Sum({1<[Unique Field]=E({<[System_Type]={"*REMOVAL*"}>} [Unique Field])>} Amount)
Hi
You can use the implicit exclusion operator or the element function E() as such.
=Sum({<[System_Type]-={"*REMOVAL*"}>} Amount)
Or
=Sum({1<[Unique Field]=E({<[System_Type]={"*REMOVAL*"}>} [Unique Field])>} Amount)