2 Replies Latest reply on Nov 17, 2017 12:03 PM by Julio Moyano

    Creating Dynamic Formula

    Julio Moyano

      Hi Everyone,

      I would like to make a calculate field to filter the variable and change the score

       

      I have this data:

       

            

      VariableShare
      variable_148%
      variable_251%
      variable_357%
      variable_458%
      variable_565%

      The calculate is:  1-((1-variable_1)*(1-variable_1)*(1-variable_1)*(1-variable_1)*(1-variable_1))

      when I take all variables, the score is  98,4%

      I would like to filter some variable to score changing

      for instance, if I am filtering variable_1 and variable_2, the score should change: 74,6%

       

      Somebody Can help me?

       

      thank you!