aggregating a column

[michaeldburt]

Hello everyone-

I'm trying to create a text object that will aggregate a column in a table.  The column is an expression that is creating totals for certain items.  I want to only the show the total for ALL items in the text object.  I've tried using the aggr function with little success.

I am trying to calculate the following:

((Standard * Actual) / Frozen) * Actual Cost

The calculation would be for each item (which has a specific value for each field), which is what I used in my aggr, but it wouldn't return any results.  Any ideas?

[Gysbert_Wassenaar]

sum(((Standard * Actual) / Frozen) * [Actual Cost])

or

((sum(Standard * Actual)) / sum(Frozen)) * sum([Actual Cost])

or

sum((Standard * Actual) / Frozen)) * sum([Actual Cost])

or

((sum(Standard) * sum(Actual)) / sum(Frozen)) * sum([Actual Cost])