Calculating data between primary & sub-report?

[lmorgan]

Not having used sub-reports before, I'm wondering if it is possible to take the results of a primary report and calculating a percentage against the results of the sub-report?

My sub-report returns a grand total of a count of loans, and my primary report returns a portion of these loans that are "aged". I would like to be able to calculate what percentage of our portfolio is aged.

Any suggestions on how to write the calculation or is it possible?

Thank you so much for any assistance you can give
Lisa

 

[lmorgan]

Sharing a litte more information to help identify the problem.

I'm using CR8.0, and I just created a shared variable in my sub-report that gives me the grand total of the number of loans represented.

 shared numbervar GrdTotal := count ({fcs_master.acct_number})

I then created a formula in the primary report that divides the total number of aged by the Grand Total of the sub-report.

 shared numbervar GrdTotal
GrdTotal / Count ({fcs_master.acct_number})

I placed this forumula in the report and when I run the report, I'm getting a return of 0.00. I thought to reverse the above formula but then I get a "division by zero" message.

Any thoughts?
Thank you!
Lisa