really having issues with formulas

[aftershokk]

I have month, product and count of product in a report.
It is grouped by month. The product count is summed in the month footer.

I added a 4th column that does a percent of total by each grouping interval which is month.
My formula works fine for the detail section but when I try to sum the percents in the detailed section I created I keep getting a "prompt box" with no results. I am taking the name of the text box witrh the formula and adding a sum(name) in the month footer section. What did I miss?

thanks!

 

[rainman89]

=sum([txtboxname]) should work!

 

[boblarson]

You have to recreate the whole formula in the group summaries. Plus, remember you can't add percents, you have to derive it from the sums of the main columns.

 

[rainman89]

im done for the day

 

[aftershokk]

My detailed textbox with the formula is named test1. I sum([test1]) in the month footer box and then a prompt appears. I thought this would be easy.

argh

 

[Rich]

As Robert has already pointed out, you can't just Sum a calculated field, you have to re-create the formula i.e


=Sum([unitcost]*[quantity])

 

[aftershokk]

I get it now

thanks everyone!!