10 Replies Latest reply: May 26, 2017 6:38 AM by sonygot g RSS

    Set Analysis  - calculate data from the past

    diane smet

      Hello,

       

      I want to calculate data from a moment in the past with a formula and set analysis, but it does not work like this

       

      =Sum({<Year_Month={"=$(=MonthName(AddMonths(Year_Month,-3)))"}>}FC_KG)

       

      Year_Month  has format 'mon YY', such as Apr 2017

       

      Thanks for you answer

      Kind regards