Different types of zeros?
The formula below is creating multiple "zeros". See pictures. What am I missing?
=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"))))))
Best Answer
-
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)?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
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)?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hard way? What's that? Swearing at the computer? NEVER.🤥
-
🤣🤣
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!