Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
May 25, 2020 11:21 AM
I have 2 fields that both sum up strings of currency. One is the sum of services and the other s a sum of the money paid in. If they total to the same, then my drawer should be balanced. The sums are the same in both fields. Originally, I had an if formula that contained the same sum action that is in {Paid In} because I would rather use an IF formula to tell me if they are the same, rather than comparing the two myself. I thought they must not be the same, so I created the {Paid In} field to check. They are indeed balanced, but the formula does not recognize this as so.
My formula:
IF({Paid In}={Gross Income},“√”,“CHECK BALANCE”)
Solved! Go to Solution.
May 25, 2020 11:34 AM
Welcome to the community, @Susan_Ferrell! :slightly_smiling_face:
The reason they’re not balancing is because you’re only seeing the “rounded” totals for both “Paid In” and “Gross Income”. If you actually change the formatting of those 2 formula fields to display more decimal points than just 2 decimal points, then you will see that there is actually a rounding difference between both of those fields.
So, one solution would be to round those numbers in your “Balance” formula like this:
IF(ROUND({Paid In},2)=ROUND({Gross Income},2),"√","CHECK BALANCE")
However, an even better option would be to go back to both your “Paid In” formula and your “Gross Income” formula, and apply the ROUND function to both of those formulas.
That way, your numbers will ALREADY be rounded by the time they get evaluated by your “Balance” formula.
p.s. If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with! :slightly_smiling_face:
May 25, 2020 11:34 AM
Welcome to the community, @Susan_Ferrell! :slightly_smiling_face:
The reason they’re not balancing is because you’re only seeing the “rounded” totals for both “Paid In” and “Gross Income”. If you actually change the formatting of those 2 formula fields to display more decimal points than just 2 decimal points, then you will see that there is actually a rounding difference between both of those fields.
So, one solution would be to round those numbers in your “Balance” formula like this:
IF(ROUND({Paid In},2)=ROUND({Gross Income},2),"√","CHECK BALANCE")
However, an even better option would be to go back to both your “Paid In” formula and your “Gross Income” formula, and apply the ROUND function to both of those formulas.
That way, your numbers will ALREADY be rounded by the time they get evaluated by your “Balance” formula.
p.s. If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with! :slightly_smiling_face:
May 25, 2020 11:52 AM
I guess there was a hiccup. I did have the round functions in the individual formulas. I refreshed the page and all is good. I knew it was something stupid. Thank you for your time.
May 27, 2020 07:53 PM
Glad to know that you got the answer you were seeking! If you would, please mark the comment from @ScottWorld as the solution to your question. This helps others who may be searching with similar questions. Thanks!