3 Replies Latest reply: Dec 16, 2011 3:56 AM by Martina Brenner RSS

    Combine two sum formulas

      Hello,

       

      How to combine into one formula:

      Sum({$<Year={$(=Max(Year)-1)}, ST={'N'}>} BALANCE)+Sum({$<Year={$(=Max(Year)-1)}, ST={'N'}>} SUBCHARGE)

       

      Additional:

      If I want to? Use sum total ?

      Sum({$<Year={$(=Max(Year))}, STATUS={'Y'}>} BALANCE)+Sum({$<Year={$(=Max(Year))}, STATUS={'Y'}>} SUBCHARGE) then divide

      Sum({$<Year={$(=Max(Year)-1)}, STATUS={'N'}>} TOTAL)

       

      Thank you.