Forum Discussion

MichaelNaser's avatar
MichaelNaser
Qrew Trainee
4 years ago

Working on Nested if Statement

Hi Everyone, I was working on a currency formula, but it looks like my nested if statement does not work properly. The formula that I have now is  If([Reimburse Amount Override]>=0,[Reimburse Amou...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Before I burn any brain cells can you tell me if on that override field you have deselected the checkbox to treat blank as zero?  ie we want to treat blank as nulls and not as zero.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MichaelNaser's avatar
MichaelNaser
Qrew Trainee
4 years ago
Mark! Appreciate your help! I forgot to deselect the checkbox to treat blank as zero. Everything is working properly!

------------------------------
Michael Naser
------------------------------