1 Reply Latest reply on May 2, 2018 10:23 AM by Michel Caissie

    Conditional Sum Calculation

    Sergey Makarychev

      Dear Experts,

       

      I am struggling with creating a calculated field, which should return a country total sales volume before introducing a product in each district (ID). For example, in the table below the outcomes should be for 50 for CA01, 0 for CA02, 258 for CA03, etc. I suspect that the expression should look similar to {FIXED[Country]:SUM(IF {FIXED [ID]:MIN([Month])}<[Month] THEN [Sales] END)}, but something is wrong here, as obviously I am confused with LoD and conditional sum parameters. Would appreciate your help. The packaged book is attached (ver. 10.5.3).

       

      Thank you,

      Sergey