Forum Discussion

ezequiel's avatar
ezequiel
Microsoft Employee
8 years ago
Solved

AND-OR on New Column

Hi   I'm trying to add a new column and using the following definition trying to combine OR/AND   = Table.AddColumn(#"Added Conditional Column1", "Compliance", each if (([Request Status] = "Pendi...
Need Help
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    Hello ezequiel

     

    Not sure about the syntax of your AND / OR

     

    The correct syntax is : AND(X;Y) / OR (X;Y) 

     

    Maybe try to add a new column and then type in : 

     

    Column = IF(AND([Compliant Request]="NO";OR([Request Status] = "Pending";OR([Request Status] = "Assigned to";OR([Request Status] = "Processing";OR([Request Status] = "Pending Approval";OR([Request Status] = "On Hold";OR([Request Status] = "Pending DocuSign";[Request Status] = "Pending Recipient Information")))))));"NO";"YES")

    Not sure about the result matching what you are looking for (we need more details to help you)

    EDITED 16h24

ezequiel's avatar
ezequiel
Microsoft Employee
8 years ago

Hi Jimmy...I checked and there are not unprintable chars. Any other suggestion? Do you see any issue on the logic I built?

 

Thanks,

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hello ezequiel

 

Not sure about the syntax of your AND / OR

 

The correct syntax is : AND(X;Y) / OR (X;Y) 

 

Maybe try to add a new column and then type in : 

 

Column = IF(AND([Compliant Request]="NO";OR([Request Status] = "Pending";OR([Request Status] = "Assigned to";OR([Request Status] = "Processing";OR([Request Status] = "Pending Approval";OR([Request Status] = "On Hold";OR([Request Status] = "Pending DocuSign";[Request Status] = "Pending Recipient Information")))))));"NO";"YES")

Not sure about the result matching what you are looking for (we need more details to help you)

EDITED 16h24