Different types of zeros?

Preston
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"))))))

Best Answer

Answers

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

    thinkspi.com

  • Preston
    Preston ✭✭✭✭✭✭

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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    🤣🤣

    thinkspi.com