percentage question

[mbDutch]

me again - hopefully an easy one:

I have a report with 2 groups.
Group 1 = Branch
Group 2 = Customer.

I have a running total field (#TotalCust) that calculates sales by customer (sum({table.sales}) for each record - reset on Group 2 - placed in GF2).
Then I have another running total (#TotalBranch) that does the same as the one above which resets on group 1 and is placed in GF1.

Now in the group 2 footer I want to add a field that displays the customer sales percentage of the final branch total. I can't do(#TotalCust) / (#TotalBranch) *100 because that will take the percentage of the running branch total and not the final branch total which is what I need.

anyone?

 

[mbDutch]

Nevermind. Got it - sorry about that

 

[lbass]

Please share your solution so others can benefit from your post.

-LB

 

[mbDutch]

I found the solution in this thread:

http://www.tek-tips.com/viewthread.cfm?qid=602112