Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, would someone be able to explain how I would be able to do a sum on the following?:
Rangesum(Above(TOTAL Sum(column1)-sum(column2),0,rowno(TOTAL)))
I'm needing to put the sum of the above into a KPI field.
Would someone be able to help me out? Cheers
Sum( Aggr( Rangesum(Above(TOTAL Sum(column1)-sum(column2),0,rowno(TOTAL))), YourDimensionsComeHere))
Replace YourDimensionsComeHere with the dimensions you need to create the table you want to use Rangesum(Above(..)).
You might need to sort the aggr dimensions using the sort order you want.
Sum( Aggr( Rangesum(Above(TOTAL Sum(column1)-sum(column2),0,rowno(TOTAL))), YourDimensionsComeHere))
Replace YourDimensionsComeHere with the dimensions you need to create the table you want to use Rangesum(Above(..)).
You might need to sort the aggr dimensions using the sort order you want.
Brilliant! worked Like a charm thanks!