2 Replies Latest reply on Sep 14, 2018 3:07 AM by Simone Antorini

    partial fixed variable

    Simone Antorini

      Hello guys!!

      how are you doing?


      I have a not easy problem


      I need to do a sum of a variable that is partially fixed to a variable but at the same time can still be influenced by other variables.


      let me explain better.



      variable x: 1,2,3,4

      variable y

      variable z


      I would like to do the sum of the sales keeping only the values 1 and 2 of variable x and still keeping the function open to filter y and z.


      I am trying to mix include and fixed but it doesn't work.


      {include:{FIXED [variable x]= '1','2':Sum([sales])}}


      if you could help me would be great!!!

      Thanks a lot in advance,