Calculating Average of 2 Group Summary Fields

[Rob2k2]

I have got 2 group summary fields which are calculating net income and number of payouts per group. In the group summary I wish to include an average net income which is netincome/number of payouts. Is there an easy way to do this?

 

[dgillz]

Just divide the two numbers as follows:

Sum({NetIncome},{GroupByField})/Count({Payouts},{GroupByField}) Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[Rob2k2]

Thanks a lot, that worked great