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

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi ezequiel ,

 

Please check if there're some unprintable characters in your column. Use trim to remove those character and try again.

 

Regards,

Jimmy Tao

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