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?

Anonymous's avatar
Anonymous
Not applicable
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?

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

Anonymous , FrankAT I think that may be at the core of my woes. The column is a product of a datediff function. I reformmated my IF statement as  IF('Inbound'[InboundTime(Hours)] <= 24 , "YES","NO") with a space after the 24 and it seems to be working, atleast for the sample data I have for now, it's returning concistent results.