Calculation in text box not working

  • Thread starter Thread starter Steven R via AccessMonster.com
  • Start date Start date
S

Steven R via AccessMonster.com

I am grouping cost by group - I want the report to look like this:

MAY COST FIGURES

GROUPHEADER=====================
Brachman Project
Total Spend: $150,000

DETAIL=============================
Engineering : $50,000 33% of total spent
Design: $100,000 67% of total

my control name in the detail section is DeptSum that shows the breakdown; I
also have a text box in the header section showing total spend by project -
it is an unbound text box with the following formula:

=SUM([Team Sum By Vendor]) - the name of that control is txtDeptSum

I want to have a text box that will show the pct breakdown in an unbound text
box - I try to put

=SUM([DeptSum]/[txtDeptSum])

in the detail section, but it doesn't work - I asked someone, and they said
don't use the control names, but I'm almost positive this should work

Any ideas ?
 
"but it doesn't work" isn't too descriptive. However, try:
=[DeptSum]/[txtDeptSum]
 
Duane,
Thanks so much - that was the trick - just leaving out the SUM part of the
equation. Sorry for the vague-ness - when I said "It didn't work," I got
message prompts referencing the names in my formulas

Steve


Duane said:
"but it doesn't work" isn't too descriptive. However, try:
=[DeptSum]/[txtDeptSum]
I am grouping cost by group - I want the report to look like this:
Click to expand...
[quoted text clipped - 27 lines]
Any ideas ?
Click to expand...
Click to expand...
 
Back
Top