Skip to Content
0
Former Member
Sep 27, 2008 at 01:54 AM

Splitting a Sum from one group member to the remaining members

51 Views

I am working with a finance chargeback report, which groups by Building and then by Department. But I can't figure out how to get the Summary of one group result to be able to distribute that summary over the other department spaces (spaces that don't have a department listed in {table.dept} field) .

GROUP1: LIBRARY BUILDING

GROUP2: FINANCE <Sum SF>

SALES <Sum SF>

ADMIN <Sum SF>

<Sum SF> so I want to take the Sum SF from the blank, divide it by the distinct count of GROUP2 but only if the list of GROUP2 has a group that's .

I have a formula that splits it, but unfortunately it does it for any GROUP1.

Does anyone have an idea on what I could do or what I need to research to accomplish this distribution to the other Group Members?

Thanks