Skip to Content
0
Former Member
Jan 23, 2009 at 09:37 PM

Totals For Groups when used twice

20 Views

I have a report that contains markets. The 1st group is putting the markets in a specified order (East and West) and totaling the original balance and outstanding balance. I have a formula that takes the original balance and divides it by the outstanding balance to give me a percentage. I have a second group also grouped by markets so I can get a total of the original balance and outstanding balance by each market. The problem is that when I go to do the percentage, it is repeating the same percentage on all of the markets. I need some help with the logic on how to get this accomplish. My 1st formula is Sum ({@ManTotal}, {BLPastDue.Region Name})/Sum ({BLPastDue.Bank Owned Bal}, {BLPastDue.Region Name})*100. The second formula is essentially the same but it is giving me the wrong answer because it can't identify which group to do (I am assuming) I tried using the Group Name field to do it like this but it doesn't work either.

IF GROUPNAME (BLPastDue.Region Name) = "OHIO VALLEY MARKET"

THEN

Sum ({@ManTotal}, GROUPNAME({BLPastDue.Region Name})="OHIO VALLEY MARKET")/Sum ({BLPastDue.Bank Owned Bal}, GROUPNAME({BLPastDue.Region Name})="OHIO VALLEY MARKET")*100.

Any ideas?

Edited by: Amber Olnick on Jan 23, 2009 10:44 PM