Indirect set analysis

[Anonymous]

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?

[MEllinghausen]

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

[Anonymous]

Hi Marcus

I noticed it returned the same value as the general recovery expression.That can't be possiblle

[MEllinghausen]

Have you clear your selections?  e.g. month??