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.
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.
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.
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.
