Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?