why the if formula doesn't work

[feiwang]

Hi, I am wondering how should I correct my formula? I want to calculate the difference of ending balance and beginning balance just for 300000+ account number.

[JosephSerpis · Accepted solution]

Hi @feiwang  this syntax should work If [Account Number]> then [Ending Balance] - [OB] Else 0 Endif you don't need " when you are dealing with numbers in formula or in a filter tool only need " for strings.

[NickSm · Accepted solution]

Hey @feiwang,

You'll want to remove the quotes around [Ending Balance] - [OB].  The quotes will take it as entering this as a string, not doing a calculation.

[Ochampo77]

 Hi Joe, I have similar formula if you can help me! Basically trying to do ABS value of more than "100000", then it's large, if ABS value is less than "100000", then it's small. Not sure why it wouldn't work.

[OllieClarke]

Hi @Ochampo77 

If you change the data type to a String, then the following formula will work:

If ABS([TCV USD]) > 100000
Then "Large"
Else "Small"
Endif

The problem with your current formula is that [TCV USD] is a numeric field, and by using quotes you're making 100000 a string. As your output is words, you need your data type to be a string too, but the comparison between 100000 and [TCV USD] has to be numeric.

Hope that helps,

Ollie