Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear fellows,
I would like to calculate a KPI.
Example:
I would like to sum up the budget as far as actual sales exist.
There are actual Sales for the month Jan.-April.
So the calculation would be:
100+50+100+25 = 275
Unfortunately my formula does not work:
If( [Actual Sales] > 0,
(rangesum(above(sum([Budget]),0,RowNo())))
,0)
Many thanks for any support!!
Best,
Markus
May be this
Sum(Aggr(If(Sum(Sales) > 0, Sum(Budget)), Month))
thank you so much!!!
Instead of using AGGR function, the Set Analysis should will be better
Sum( {$ <[Month]={"=Sum([Actual Sales])>0"} >} Budget)