Forum Discussion

Hadill's avatar
Hadill
Helper I
4 years ago
Solved

If-else-else Error

I tried many ways to write the If- else quiery, and ever time I get the same error an I dont know the reason, I think I apply the right quirey.

Is anybody have any explanation for that?

 

Thanks in advance

 

Interesting Links
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Hadill ,

     

    Try pasting this into a new custom column window:

    if [Funnel Status] = "Booked" or [Funnel Status] = "Signed" or [Funnel Status] = "Committed" then "Forecast" else "Active"

     

    Pete

6 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi Hadill ,

     

    Try making the following changes to remove the error:

     

    1) Make sure that your third reference to [Funnel Status] is spelt correctly.

    2) Make sure there is a space between "Committed" and 'and'

    3) Make sure the keyword 'if' is lower case

    4) Remove the semicolon ';' at the end

     

    I also think you will need to correct your evaluation as a single field can't be "Booked" AND "Committed" AND "Signed" all at the same time - you may need the OR operator here.

     

    Pete

  • Hadill's avatar
    Hadill
    Helper I
    4 years ago

    Hello BA, thanks for your reply !

     

    I fixed my queiry as per your comments, but I still have the same issue. 

    • BA_Pete's avatar
      BA_Pete
      Super User
      4 years ago

      Hi Hadill ,

       

      Can you post the code as it appears now after the changes please?

       

      Pete

      • Hadill's avatar
        Hadill
        Helper I
        4 years ago

        Hi BA_Pete 

         

        here we are, I tried to change the code body.

        I was wondering if there any thing have to be done with the settings to enable this case?