Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This expression calculates Recovery
SUM(PAY_AMOUNT) - Sum ({<PAY_DR_YEAR = P(SALES_DR_YAER)>}PAY_AMOUNT)
now i want to break down the resultant figure into it's actual year of recovery or even if possible previous months
I tried this for the year
SUM({$<Year = {'=$(=Max(Year)-1)'}>}PAY_AMOUNT) - Sum({$<Year={'=$(=Max(Year)-1)'},PAY_DR_YEAR = P(SALES_DR_YAER)>}PAY_AMOUNT)
but the results was'nt right.
Any Help?
Hallo,
try this one
SUM({$<Year = {"$(=Max(Year)-1)"}>}PAY_AMOUNT) - Sum({$<Year={'"$(=Max(Year)-1)"},PAY_DR_YEAR = P(SALES_DR_YAER)>}PAY_AMOUNT)
Marcus
Hi Marcus
I noticed it returned the same value as the general recovery expression.That can't be possiblle
Have you clear your selections? e.g. month??