Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

parent $1 less than the sum of its whole number children

ctc
ctc ✭
edited 12/09/19 in Archived 2016 Posts

Does anyone know why a parent would be $1 less than the sum of its whole number children?

Tags:
· Share on FacebookShare on Twitter

Comments

  • Scott Lynch
    Scott Lynch ✭✭
    edited 11/04/16

    Do you have any blank rows within the children that are not indented under the parent?

    · Share on FacebookShare on Twitter
  • ctc
    ctc ✭

    Hmm... There are grandchildren and great-grandchildren rows where the column in question is blank. There is also a second parent on the page whose sum of its children is zero.

    · Share on FacebookShare on Twitter
  • Benjamin Walker
    Benjamin Walker Employee

    Have you you tried increasing the decimal on all cells to get numbers that are not rounded?

    You can do so by clicking the left of the two circled buttons here:

     

    Increased-Decreased.PNG

    · Share on FacebookShare on Twitter
  • ctc
    ctc ✭
    edited 11/04/16

    Why would I do that? To achieve what I see you would change the decimal on your parent so that it rounds to nine. But in my case it would show eight.

    · Share on FacebookShare on Twitter
  • Benjamin Walker
    Benjamin Walker Employee

    I'm not sure. The values are stored as whatever they were inputted as, even if you reduce the visible decimal. If you have explicitly set some cells to round and others to not to I could see t being the cause of your problem. If I had more information I could likely help you diagnose your issue.

     

    For example. If I used rounding on all involved cells and did a SUM(CHILDREN()) of: 2.5 and 2.5 I would get 5 as a result, but the two cells would have been rounded to 3 visually.

     

    This can be seen here:

     

    If this is not the case, providing more details would certianly help me diagnose your problem :)

     

    rounded.PNG

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories