Forum Discussion

sully343's avatar
sully343
Frequent Visitor
3 years ago
Solved

Multiple If statement

I've tried multiple ways and can't seem to get this to work...   I want to look at the columns FMLAIntermittent and Assignment    If FMLAIntermittent is null and assignment is not: Training, Othe...
Need Help
  • Samarth_18's avatar
    Samarth_18
    3 years ago

    Hi sully343 ,

     

    You could try below code:-

    OPS =
IF (
    AND (
        LongTermLeaveStatus[FMLAIntermittent] = BLANK (),
        LongTermLeaveStatus[Assignment] IN { "Training", "Other" }
    ),
    "Ops",
    BLANK ()
)
Samarth_18's avatar
Samarth_18
Community Champion
3 years ago

Hi sully343 ,

 

You could try below code:-

OPS =
IF (
    AND (
        LongTermLeaveStatus[FMLAIntermittent] = BLANK (),
        LongTermLeaveStatus[Assignment] IN { "Training", "Other" }
    ),
    "Ops",
    BLANK ()
)
sully343's avatar
sully343
Frequent Visitor
3 years ago

That worked! I just switched the "ops" and Blank response, but it did what I needed it to! Thank you!