If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SubReport Field / Report Field = %
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 |
#2
|
|||
|
|||
SubReport Field / Report Field = %
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]) -- Duane Hookom Microsoft Access MVP "Stacey Crowhurst" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|