2 Replies Latest reply: Feb 17, 2017 8:08 AM by Роман Горбунов RSS

    Previous period sum formula

    Роман Горбунов

      Hello everyone,

       

      i have such an issue - there is sales sum in several months and i need to get previous period sum (in that case previous month) while selected one certain month. I have tried about 5-6 formulas and no one works, for example:

       

      Sum({$<Month={"$(=Max([Дата.autoCalendar.Month])-1)"}>}  [Sum] ) - this shows the same sum (selected and previous month), though there is another sum in previous month.

      Снимок.PNG

      Could anyone help me?