Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

2 Replies
giakoum
Partner - Master II
Partner - Master II

if(flag=1, if([Sales Region Type]='Global', GlobalRevenue, RegionalRevenue))

just add the else statements as well

Not applicable
Author

Thank You -- It did work!