Calculate Percentage by dividing same field from different part

[emncwundy]

I want to run a report which works out the sales success rate of quotes submitted to clients for a particular month.

The report sorts the records by quote status (approved; pending).

The sub summary when sorted by quote status shows the running total value of approved and then pending.

I want to calculate the percentage of approved for that month so i can track the monthly sales conversion rate.

I cant work out how to do this since its the same field but in different part that i basing the calcluation on. I'm guessing there is probably a very simple solution to this but I have no idea where to start.

Please help!!

[comment]

Have a look at the GetSummary() function.