different variable formula based on a field selection

VC1258 — Mon, 28 Aug 2023 21:12:01 GMT

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?

Re: different variable formula based on a field selection

Digvijay_Singh — Tue, 29 Aug 2023 03:41:35 GMT

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?