Forum Discussion

DMB90's avatar
DMB90
Helper II
4 years ago
Solved

OR Statement with Two Different Criteria

This is my formula. I'm trying to say if either 4.IA Due Date = 0 or
[0.1 Adj Test Phase="Interim (1)" and T2 Due Date = 0], then say "Unscheduled" and if not then say "Scheduled"
 
Formula:
2.Scheduled vs. Unscheduled = IF('Control Testing'[4.IA Due Date]=0 || ('Control Testing'[0.1 Adj Test Phase]="Interim (1)"&&'Control Testing'[T2 Due Date]=0),"Unscheduled","Scheduled")
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi DMB90 ,

     

    Please try this code.

    2.Scheduled vs. Unscheduled =
IF (
    OR (
        'Control Testing'[4.IA Due Date] = 0,
        AND (
            'Control Testing'[0.1 Adj Test Phase] = "Interim (1)",
            'Control Testing'[T2 Due Date] = 0
        )
    ),
    "Unscheduled",
    "Scheduled"
)

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi DMB90 ,

     

    Please try this code.

    2.Scheduled vs. Unscheduled =
IF (
    OR (
        'Control Testing'[4.IA Due Date] = 0,
        AND (
            'Control Testing'[0.1 Adj Test Phase] = "Interim (1)",
            'Control Testing'[T2 Due Date] = 0
        )
    ),
    "Unscheduled",
    "Scheduled"
)

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.