Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use Set Analysis for a not equal to value.
=Sum({$<[Flag]-={'x'}>}[Amount])
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?
May be this:
=Sum({$<[Flag] = e({<Flag = {'x'}>})>}[Amount])
Try with out $ ,
As it is looking fine , can you post your sample app so that i can help easily.
Sunny,
That expression just returns $0.
Agnivesh,
Taking out the $ also gives me $0.
I am essentially trying to replace this expression with Set Analysis:
=Sum(If([Flag]<>'x',[Amount]))
Is there a sample you can share?
Not really as you have seen before, the file is quite large and I cannot just parse out the relevant data.
You can also try like below:
Exmple: Sum( {<Year -= {2016}>} Sales)
I hope thi may helps you.
-Nagarjun
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
Try =Sum({$<[Flag] = - {'x'}>}[Amount])
I have tried that as well and it produces a value of $0.