This content has been marked as final.
Show 4 replies

1. Re: Sets and calculated fields
Manideep Bhattacharyya Jul 2, 2016 9:09 AM (in response to lavanya koneru)IF [top25] = TRUE then sum([number of sales]) END
you may write
IF [top25] then sum([number of sales]) END
both of the expression does the same thing.

2. Re: Sets and calculated fields
lavanya koneru Jul 2, 2016 10:45 AM (in response to lavanya koneru)I meant this way is not working.,we get an error cannot keep boolean and aggregate expression.
IF [top25] then sum([number of sales]) END

3. Re: Sets and calculated fields
lavanya koneru Jul 2, 2016 11:37 AM (in response to lavanya koneru)If attr(top25)="In" then sum(number of Sales) also did not work.Please suggest how to use sets effectively in calculations.So far no luck as I tried multiple ways to get sum of top 25 sales using set.

4. Re: Sets and calculated fields
Shinichiro Murakami Jul 2, 2016 1:32 PM (in response to lavanya koneru)You don't need to put that formula.
Ony put this formula, and put "Set" into Column , Row, or Label.
SUM([Number of Sales])
/
SUM({FIXED [DateMonth] : SUM([Number of Sales])})
Just like your last case.
USing LOD expression and group by
Thanks,
Shin