Forum Discussion

guna_knp's avatar
guna_knp
Regular Visitor
2 years ago
Solved

Unable to implement IF and Text contains in m Query

HI,    I am trying to implement below M query, however gets the error message "Token 'Then' expected", can somebody help me here   if Text.Contains([Manager],"On Leave") AND [Grandparent]="" THEN...
Need Help
  • collinq's avatar
    collinq
    2 years ago

    Hi guna_knp ,

     

    I beleive that the "then" and the "else" need to be lower case.  Try that and let us know.

  • shafiz_p's avatar
    shafiz_p
    2 years ago

    guna_knp M code is case sensitive. For your case, you have to use all lower case for "AND", "THEN", "ELSE".

     

    Check here for list of operators 

    Hope this help.

    If this answered your question, please accept this as a solution!!

shafiz_p's avatar
shafiz_p
Super User
2 years ago

guna_knp M code is case sensitive. For your case, you have to use all lower case for "AND", "THEN", "ELSE".

 

Check here for list of operators 

Hope this help.

If this answered your question, please accept this as a solution!!