I'm trying to calculated weighted averages of percentages in Crystal, but groups. Each item has a balance, and a percentage. I then summed the balances per group and have them in the group footer. I now need to calculate the WAY with the following formula:
WAY= Acct Balance/Total Balance of Group*Interest Rate of the Acct.
Is there a way to get Crystal to pull this information?