Different types of zeros?

Preston

The formula below is creating multiple "zeros". See pictures. What am I missing?

=IF([email protected] = "ERROR", "ERROR", IF([email protected] = "TBD", "TBD", IF([email protected] = "DEDUCT", "DEDUCT", ((SUM([email protected]:[email protected]) + SUM(CHILDREN([email protected]:[email protected]))) - (((SUM(CHILDREN([Contract Amount]@row), "Change") + ([Contract Amount]@row)) - [Invoiced Last Year]@row) - SUM(CHILDREN([Invoiced Last Year]@row), "Change"))))))

Paul Newcome

Could it be a rounding thing where 0 is displayed but the stored value is actually 0.01 or something along those lines? And then the other 0 could be a "true" zero (0.00)?

Paul Newcome

Could it be a rounding thing where 0 is displayed but the stored value is actually 0.01 or something along those lines? And then the other 0 could be a "true" zero (0.00)?

Preston

Paul,

You're a smart cookie. I like you.

I also appreciate your continued efforts to sort shenanigans like this out via this forum.

I hope you have a pleasant day!

Sincerely,

Preston

Paul Newcome

Happy to help! 👍️

If it makes you feel any better... Most of my knowledge surrounding sorting out problems/issues has come from learning the hard way. I'm surprised I don't have my own office yet simply so that my coworkers don't have to listen to me cursing my computer on a regular basis. Hahaha.

Preston

Hard way? What's that? Swearing at the computer? NEVER.🤥

Paul Newcome

🤣🤣