Hello All,

I have a report showing a list of sales calls, sorted by salespeople.

There is a summary set for each person that tallies the number of calls they ran, the number of sold jobs and the total Sales in Dollars.

In the Header I have a calculation that divides the Summary TotalCallsSold by the Summary TotalCallsRan, resulting in an overall closing ratio.

QUESTION:

How can I get a ratio per salesperson to show up on the Sub-Summary line?

Collins,

Apologies if I don't understand your predicament precisely enought to provide an exact calc, but I think you need to use the GetSummary function. Something along these lines:

PersonRatio =

GetSummary ( TotalCallsSold ; Person ) / TotalCallsSold

Does that help?

Debi Rubel

FullCity Consulting