Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Nested IF Based on two cummulative conditions

Hello,   I have this table: Order Criteria 1 Criteria 2 1 100% BLANK Value 2 90% BLANK Value 3 85% 25% 4 100% 100%   Now I want to create a Status column that basical...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    PO Status =
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
    IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
Please try

PO Status =
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
    IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )