YTD Calculation

[mhmmd_srf]

Hi All,

I have to show YTD Sale on the basis of selection.

If user Year = 2016 and Month = 5

YTD should show summation of Month = 1,2,3,4 and 5.

My expression is :

sum({<CstFiscalPeriod <= {'$(=$(vMaxMonth))'}, CstFiscalYear = {'$(=$(vMaxYear))'}>} UnitActual)

But it is throwing error.

Please help.

Thanks,
Sarif

[sunny_talwar · Accepted solution]

May be try this:

Sum({<CstFiscalPeriod = {'<=$(=$(vMaxMonth))'}, CstFiscalYear = {'$(=$(vMaxYear))'}>} UnitActual)