Search for answers here or ask a question
0

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")

Thanks

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.

    Like
  • Perfect, thank you.

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