I am trying to use Set Analysis for a not equal to value.
This is not working properly. When I change -= to just = , I get the correct amount for the ones that should be equal to x. How should I write this to sum the Amount where the Flag is not equal to x?
That expression just returns $0.
Taking out the $ also gives me $0.
I am essentially trying to replace this expression with Set Analysis:
What does If([Flag]<>'x' returns, it is NULL or you have a value for it like Flag<>'x' is 'Y','Z' etc, as NULL would be a problem in Set Analysis