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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
carlovsky
Helper II
Helper II

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"))

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @carlovsky 
Please try

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

View solution in original post

2 REPLIES 2
carlovsky
Helper II
Helper II

So simple and so effective. Many thanks !!

tamerj1
Super User
Super User

Hi @carlovsky 
Please try

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors