Skip to Content
May 26 at 07:52 PM

Weighted Average Yield

63 Views Last edit May 27 at 01:58 PM 2 rev

Hi there,

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?