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