Different types of zeros?

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

2020-03-19 14_06_19-Forecast 2020 - Smartsheet.com.png

2020-03-19 14_07_00-Forecast 2020 - Smartsheet.com.png

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

Find more posts tagged with

Formulas

functionality

Conditional Formatting

Accepted answers

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)?

All comments

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

🤣🤣

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.