SubReport Field / Report Field = %

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
 
D

Duane Hookom

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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top