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.