Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
For the Below dataset:
How to calculate cumulative YTD
Below is the expression for my YTD and Variable expression:
YTD Expression:
NUM(SUM({<L2-={'TOTAL'},[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset,Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},
[Year Month Base (YYYYMM)]={">=$(=($(vYTDMin)))<=$(=$(vYTDMax))"}>}VV/$(pSwt_Unit)),'#,##0')
vYTDMin
Date(YearStart(max({<"Year_Offset"={0},"Year Month_Offset"={0},"Year Quarter Offset"={0},"Year half year offset"={0}>}PERIOD_FACT),0),'YYYYMM')
vYTDMax
Date(max({<"Year_Offset"={0},"Year Month_Offset"={0},"Year Quarter Offset"={0},"Year half year offset"={0}>}PERIOD_FACT),'YYYYMM')