3 Replies Latest reply: Dec 3, 2012 7:05 AM by Adotey Kwame RSS

    Indirect set analysis

    Adotey Kwame

      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?