Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Token then expected error

I am experiencing a token then expected error for the following code with the first AND underlined in red:

if [rev] <1 then "Stopped"
else if [rev] >= 1 AND [rev] <= 100000 then "Below $100K"
else if [rev] > 100000 AND [rev] <= 500000 then "Between $100K and $500K"
else if [rev] > 500000 AND [rev] <= 1000000 then "Between $500K and $1M"
else if [rev] > 1000000 AND [rev] <= 5000000 then "Between $1M and $5M"
else "More than $5M"

 

how can i get rid of this error? 

  • Hi Anonymous ,

     

    Try writing all the "AND"s in lowercase as "and".

    M language is entirely case-sensitive, so this is probably the issue.

     

    Pete

2 Replies

  • Hi Anonymous ,

     

    Try writing all the "AND"s in lowercase as "and".

    M language is entirely case-sensitive, so this is probably the issue.

     

    Pete

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks BA_Pete ! That solved my issue 🙂