The alternative to a difference function to build a waterfall

Hi guys,

I am trying to make a calculated field which will be pretty much the “difference” function which will include T-0 period in order to build yearly results waterfall.

Nevertheless, I failed. I tried nearly every function with “period” but without success.

The one which, perhaps, can solve is the periodOverPeriod() - but I am unable run it all. Hence, I can not find anything related to this function.

Alternatively, ifelse() with a difference but there’s no way to mix aggregate with non-aggregate functions.

Any tips?

Thanks for reporting this issue. We will need more information to dive deep into the actual problem and identify solution. Please contact us via so that we can work with you on this more directly.