3 Replies Latest reply: Mar 15, 2017 3:50 PM by Shahbaz Khan Mohammed RSS

    Cumulative sum (Set Analysis)

    sebastian londono

      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