This content has been marked as final. Show 2 replies
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.