3 Replies Latest reply: Mar 15, 2017 3:50 PM by Aehman K RSS

    Cumulative sum (Set Analysis)

    Sebastian Manar

      Hi everybody,

       

      I have a problem with a set analysis.

       

      I need to sum values depends on which month is selected. For example

       

      I have two fields: Final Cost and PPTO

       

      For January: Sum(Final Cost) / Sum({<Month={feb,mar,apr}>}PPTO) // but i need this dynamic

       

      The rule is: Sum of Final Cost of the current month / Sum of PPTO of the next three months

       

      Hope you can help me