Forum Discussion
Solved
Multi Condition Statement to Set a Variable
I am looking to create a variable called DIFF that is set to a specific number based on the value of a text string called STATUS. Basically - If STATUS=Submitted then DIFF=14 or If STATUS=Active...
Var diff =
Switch(
Selectedvalue( table[status] ),
"Submitted", 14,
"Active", 21,
"On hold", 28
)
Worked great, thanks!
