vendredi 2 février 2018

CUMULATIVE SUM WITH IF CONDITION

i got a big confusion,

if(

month(Months)<=Month(today())

,(rangesum( above( sum({$<[type]={'Actual CAPEX'}>} value),0,rowno()))) ,

(rangesum(above(sum({$<[type]={'Forecast CAPEX'}>} value),0,rowno()))))

this condition is working properly but there is a problem is:-

for example we are in March so, values of Actual should become Forecast

i mean cumulative of ACTUAL should replace cumulative of FORECAST (TILL DATE).

Thanks & Regards

Agrim

enter image description here

Aucun commentaire:

Enregistrer un commentaire