The value returned by a summary field depends on the context in which it is used. When used in a calculation, the value returned is a "grand total" value based on the current found set. In order to access the sub summary layout part based sub-total, use the getSummary function and specify the same field specified as the "sorted by" field for the sub summary part as the "break field" parameter in the sub summary function call.
One small but important difference between GetSummary and sub summary layout parts is that getsummary requires that the summary field, the break field and the calculation field using getSummary all be defined in the same table. (The "sorted by" field in a sub summary layout part can, on the other hand, be from a related table.)
I will look at that now.
I am trying to do what you replied but could you check if this appears correct to you...
GetSummary (TotalCountQualifying Lead;CountQualifyingLeads)/GetSummary(TotalCountOnCoverLeads A;Count of On Cover A)
The break fields look wrong to me. I don't imagine that you are actually sorting records on CountQualifyingLeads and Count of On Cover A but I'm just going by the field names here. In place of those two fields, you need the "sorted by" fields from the corresponding sub summary layout parts where you see the sub totals that you want to use in the calculation.
I only have only one Sub Summary area as I only want one line per advisor, this is set to as sorted by "Advisor" field
However as I am getting totals for many things in that Sub Summary area so I am sorting by many other fields to get my results
Advisor - Client ID - CountQualifyingLeads - CountLeadsReceived - CountOnCover plus others
I am now trying to get the conversion rate between TotalLeadsQualified and TotalOnCover
The Two fields when in the sub summary give me the correct results but I can not seem to get the conversion rate to do the same.
To get the right counts I am using the Sum the reciprocal approach you showed me in a previous approach.
Then "Advisor" is the field that should be specified as the "break" field in the two getsummary function calls.