Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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])