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.

       

      sales

      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,

      Simone