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

# Creating Dynamic Formula

Hi Everyone,

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

I have this data:

 Variable Share variable_1 48% variable_2 51% variable_3 57% variable_4 58% variable_5 65%

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!

• ###### 1. Re: Dynamic Calculate

Hi Julio,

Can you explain a bit and attach some data or packaged workbook. This looks Confusing to me.

Thanks

deepak

• ###### 2. Re: Dynamic Calculate

Hi Deepak,

I have five variable and I want to make a formula.

the formula is 1-((1-(variable_1)*(1-(variable_2)*(1-(variable_3)*(1-(variable_4)*(1-variable_5))

but, I want to filter some variable and the results changing automatically.

for instance, I filter variable_1 and variable_2 then the results should change

thanks