Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I and looking to create a if statement in a chart expressio. For example
if status = 1 then given
if status =2 then refused.
I Am trying to find a way to make this all one statement.
This should be enough
Pick(status, 'Given', 'Refused')
Because match will also assign 1, 2 value to status which is its value already
May be this?
= Pick(Match(status, 1, 2), 'Given', 'Refused')
This should be enough
Pick(status, 'Given', 'Refused')
Because match will also assign 1, 2 value to status which is its value already
Yeah, you are right. Got it.