2 Replies Latest reply: Apr 1, 2014 2:44 PM by Suzanne Robinson RSS

    IF/THEN statement in an Expression

      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.