SUM Multiple Columns on a Report?

[bmsrmd]

I can't seem to find a way to SUM two seperate columns on my report. I've attached an example of what I am talking about. I was able to add the SUM feature to the 'Estimate' column, but it doesn't allow me to add that to the 'Plan' column too. The only options available are Count Records or Count Value.

Any ideas on how I can have these both SUM seperately within their columns?

 

[pbaldy]

=Sum(Plan) should sum the other.

 

[bmsrmd]

I tried that method, but I get an error when I test it out:

"This expression is typed incorrectly, or it is too complex to be evaluated."

I've double checked several times to make sure I had typed it correctly. That shouldn't be the issue.

=Sum([Plan])


Any ideas why the formula is working for the estimate column but not for the other one?

 

[pbaldy]

Where do you have it? That should work as the control source of a textbox in the report footer. Can you post the db here?

 

[Pat Hartman]

is Plan defined as numeric? If it is not, you won't get a Sum() option or any other option that requires numeric values.

 

[bmsrmd]

That solved the problem! One of the tables (that is pulled out of an external system) had that column defined as text instead of numeric for some reason.

Thanks for the help pbaldy and Pat!