Forum Discussion

eWise's avatar
eWise
Icon for Helper II rankHelper II
5 years ago
Solved

Inconsistent IF statement

Hi all, I have a simple IF statement which is returning inconsistent results and I can'T figure out why. I would greatly appreciate any help in this. This is the IF statement where I want it to retu...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I would assume that the first column is not formatted correctly. Can you check that it's stored as whole number/decimal number?

FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
5 years ago

Hi eWise ,

you try an alphabetical compare of text "24", so your "inconsistent results" are in this term correct.

If you want a numerical compare you can do it like this:

 

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)