Sum of Parent row

Ken Hoffman

Hello,

I am trying to sum the totals of my parent rows and not include my children rows. Any help is appreciated.

L_123

Or, if your parent columns are just adding the children columns together, the result should be twice what you need. So you can just add them all together, then divide by 2.

L_123

Helper:

=if(count(ancestors())>0,1,0)

then

=sumif(helper:helper,1,[total earnings]:[total earnings])

L_123

Or, if your parent columns are just adding the children columns together, the result should be twice what you need. So you can just add them all together, then divide by 2.