I have created this chart which shows Actual expenditure (green) vs. Expected expenditure (black) using RUNNING_SUM. However, I would like the green curve to stop at 'Today'. In my initial attempt I tried to set up an IF-statement, but obviously it doesn't work since RUNNING_SUM is an aggregate
Any suggestions?
4 answers
Hey @Morten Toft Rasmussen ,
wrap your Dato with Min function i.e
IF min([Dato])<=[Today Parameter] THEN [Agg. Actual Expenditure]
END
I hope this help
