Accumulated values

[markusblaut]

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

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(If(Sum(Sales) > 0, Sum(Budget)), Month))

[markusblaut]

thank you so much!!!

[shivanandk]

Instead of using AGGR function, the Set Analysis should will be better

Sum( {$ <[Month]={"=Sum([Actual Sales])>0"} >} Budget)