Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
good afternoon! please tell me how to make all the values of the variable (there are more than a hundred of them) recorded in one field, for example Threshold-1
and in the application itself, I could select the value of this variable through the variable input and all formulas that have this Threshold-1 field were recalculated
hi ,
if you want to filter the variable you can use set analysis to perform the action using variable input in 1 variable & reducing the numbers using set analysis
create variable = vVariableName
vVariableName value =1
{<field={"$(vVariableName)"}>}
Value will look like
{<field={"1">}
field will filter value 1 as if u have multiple u can add
{<field={"$(vVariableName)"},field2={"$(vVariableName)"},field3={"$(vVariableName)"}>}
thanks
=Concat(DISTINCT [Threshold-1], ',')
-Rob