Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have field named "num" that contains a number from 1 to 5 and I have variables named v_1, v_2 ,,,, v_5 that contain set analysis.
I want to call these variables automatically in a tab according to the fields.
$ = '(v _' & num & ')'?
Im looking if i can do that without using if statement ?
thank you
Hi!
Use
$(='v_' & Only(num))
in your expression.
regards,
Jaime.
hi thank you but it doesn't work !
Hi
How are you using your variable and where? Note that the expression I provided works only if there is one and only one "num" selected.
I attach a sample file where you can see that it indeed works.
Regards,
Jaime.
I use the variable in a table as a measure
Hi again!
My bad, I didnt remember that you needed it a chart in order to modify set expression. Use something similar to
=Sum( $($(='v_' & Only(Num))) Amount)
I attach an APP so you can see how I built it.
Regards,
Jaime.