Search for answers here or ask a question

Condition Or / And in Model Data flow functions

how can i apply a condition Or / And in calculation column ?

this syntax generates an error :

if([Test_CP] !=="P" or [Test_CP] !=="F" ,"Chambre double","Chambre particulière")

This one too :

if([Test_CP] !=="P" || [Test_CP] !=="F" ,"Chambre double","Chambre particulière")


2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Laurent,

    Currently, you can use the "equals" function  instead of the equals sign.

    For example, you can try something like this:
    if(equals([Country],"US") || equals([Country],"UK"),"English","Other")

    However, we currently do not support using "not equals". This will be added soon.

    As this is the case, perhaps instead of using not equals, you can see if reversing the order of the items in the if statement.

  • Perfect, thank you.

Like Follow
  • Status Answered
  • 4 yrs agoLast active
  • 2Replies
  • 27Views
  • 2 Following