Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Nested IF Based on two cummulative conditions

Hello,

 

I have this table:

OrderCriteria 1Criteria 2
1100%BLANK Value
290%BLANK Value
385%25%
4100%100%

 

Now I want to create a Status column that basically follows the assumptions below:

- Criteria 1 threshold = 100%

- Criteria 2 threshold = 0%

- If one the above assumptions doesn't follow the threshold we should mark the line as Rejected

 

Example of my goal:

 

OrderCriteria 1Criteria 2Status
1100%BLANK ValueAccepted
290%BLANK ValueRejected
385%25%Rejected
4100%100%Rejected

 

Can you please help me?

 

I'm trying with this, but no success so far

 

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

 

  • Hi Anonymous 
    Please try

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    So simple and so effective. Many thanks !!

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi Anonymous 
    Please try

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