Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create an expression with an "IF/THEN" statement; and while the expression is checked as "OK", it does not return any value. I tried different "ways" but still not getting any values; so I was wondering what am I missing?
I am basically asking that if there is a flag of "1" and Sales Revenue is "Global; then return the "Global" Revenue ; otherwise return "Regional" revenues if the Flag is still "1"
=if(Min(if(Flag=1,[Sales Region Type]='Global', Revenue), min(if(Flag=1,[Sales Region Type]='Regional',Revenue))))
Thanks for the help.
if(flag=1, if([Sales Region Type]='Global', GlobalRevenue, RegionalRevenue))
just add the else statements as well
Thank You -- It did work!