M Language : If with multiple conditions

[Raph]

Hello,

I am trying to write a formula saying : if both conditions (Historique >2000 and royalties < 0.22) are fullfilled it should return "To adapt"... otherwise it returns OK.

In the formula below, it returns "Error"  for each line where Historique > 2000. Could you please help me to solve this ?

= Table.AddColumn(#"Royalties exception développé", "Check royalt. > 2000", each if [#"Historique "] > 2000 and [#"Royalties exception.%roy."] < 0.22 then "To adapt" else "OK")

Thank you very much.

Best regards

Raphaël

[parry2k]

@Raph what is the data type of historique column, make sure it is number.

[Raph · Accepted solution]

Hello @parry2k 

Thank you for your answer. This column is number type... in the meantime I tried this

= Table.AddColumn(#"Colonnes supprimées", "Check royalt.", each if [#"Historique "]>2000 and [#"Royalties exception.% roy."]<0.22 then "TO ADAPT" else "OK")

And it seems to work... Not sure to understand why.

Thank you for your time.

Raphaël

[parry2k]

@Raph interesting, can you try to rename this column name to the name you originally wanted, just wondering what is causing that you cannot have that column name, may be > this symbol but good to check though.

ANyhow, your problem is solved 🙂

[Raph]

@parry2k  It works also with the previous column name... the only differences are the spaces that I removed next to the > and < in the formula.

Thank you

[parry2k]

@Raph good to know, totally weird. I would like to test it any end. Anyhow, thanks for letting me know.