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
Aucun commentaire:
Enregistrer un commentaire