different variable formula based on a field selection

[VC1258]

Hi All,

I am have 2 different variables, each one has a different formula:

ValueSelected = count(distinct if([FieldSelected]='X',0))

Variable1 = [MyField1]+[myField2]-[myField3] e.g. [10] + [5] - [1] = 14

Variable2= Money(Alt(Sum([myField]), 0)) 

When the user selects a specific value, I need it to go to variable 1, if not, then variable 2.

This is what I have been trying so far but it hasn't worked:

=if([ValueSelected] = 1, $(Variable2),$(Variable1))

How can I do this?

[Digvijay_Singh]

Can  you elaborate further what is 'ValueSelected', is it a filterbox object expression where you are making selection?

Why variable1 fields are not surrounded by aggregation function like you got for variable 2?