SubReport Field / Report Field = %

  • Thread starter Thread starter Stacey Crowhurst
  • Start date Start date
S

Stacey Crowhurst

Hi! I have a report [rptProjectedCostSummaryFinal] with a subreport
[rsubCauseCodeAllocation].

The report is like so....
Details details details $$$$$$
Details details details $$$$$$
Total Budget Total Committed Total Uncommitted Total Projected Total
Variance

The subreport is like so...
CauseCodeDesc Amount
1. Base Scope $50,000
2. Stakeholder $500
3. Error & Omission $2,000
4. Job Field $675
Total $53,175

What I want to happen is for each of the four cause codes to show what
percentage each is of the total projected costs like so...
CauseCodeDesc Amount
1. Base Scope $50,000 80%
2. Stakeholder $500 1%
3. Error & Omission $2,000 3%
4. Job Field $675 1%
Total $53,175

How do I create a text box with a percentage formula of [subreport amount] /
[report amount]? Please let me know what other information you need. I
appreciate your help!

Thanks!
Stacey
 
Your subreport records seem to total 53175 so you can use a text box in the
subreport with a control source of:
=[Amount]/Sum([Amount])
 
Back
Top