SubReport Field / Report Field = %
in [Reports]
|
Prev: how do I activate horizontal or vertical position on report
Next: Conditional format based on 2 records
From: Stacey Crowhurst on 13 May 2010 17:28 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
From: Duane Hookom on 14 May 2010 09:38
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 |