19 Replies Latest reply: Apr 20, 2016 8:40 PM by Sunny Talwar RSS

    How to sum all Amount from Day 1 till today using SET ?

    PAUL YEO

      Hi All

       

      when i filter Reporting Code = 50010 , correct result is -120,107,846.65

       

      = money(

      if([Exec P&L Level] = 's','',Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}[Amount]*-1)/1000)

      , $(vMoneyFormatK_GL))

       

       

      Now i get 14,031.85 K , may i know how to make it -120,107,846.65 ? when i dont select month and year.

       

      Paul