K
Kevin Sprinkel
I have a report consisting of ten subreports that
summarizes the results of our construction estimating vs.
actual received bids. Ported from a difficult-to-maintain
and customize Excel spreadsheet, we can now "slice-and-
dice" the selection criteria for the report by Bid Amount,
Client, Building Type, etc.
What I'd like to add are three summary fields in the
report header, that require a sum of controls in a
subreport:
Description Relevant Control(s)
====================== ===============================
Avg Cost of All Bids rsubBidReturnAwardedCost.Amount
Delta of Us vs. Bids rsubBidReturnAwardedCost.Amount
rsubLastEstimate.Amount
Delta would be (SumofBidAmount-SumofLastEstimateAmount)/
SumofBidAmount, formatted as a percentage.
Something like:
COST DELTA NOTES
=========== ======= ==================
AVERAGE $10,000,000 - 2.3% 220 Total Projects
Can anyone tell me how to get these summary numbers?
Thank you.
Kevin Sprinkel
summarizes the results of our construction estimating vs.
actual received bids. Ported from a difficult-to-maintain
and customize Excel spreadsheet, we can now "slice-and-
dice" the selection criteria for the report by Bid Amount,
Client, Building Type, etc.
What I'd like to add are three summary fields in the
report header, that require a sum of controls in a
subreport:
Description Relevant Control(s)
====================== ===============================
Avg Cost of All Bids rsubBidReturnAwardedCost.Amount
Delta of Us vs. Bids rsubBidReturnAwardedCost.Amount
rsubLastEstimate.Amount
Delta would be (SumofBidAmount-SumofLastEstimateAmount)/
SumofBidAmount, formatted as a percentage.
Something like:
COST DELTA NOTES
=========== ======= ==================
AVERAGE $10,000,000 - 2.3% 220 Total Projects
Can anyone tell me how to get these summary numbers?
Thank you.
Kevin Sprinkel