Subtotals when using an expression

[#1]

Hi,

I seem to be having a problem with getting my subtotal to work for a calculated field in a straight table.

The calculated field is an average of full cost.

The subtotals is showing me the average of the full cost for all rows instead of the total.

Please see below settings on Presentation tab for this field and let me know if I missing anything.

Thanks for your help.

Archie

[wgonzalez]

Try this: Full Cost / sum(TOTAL Full Cost)  This will be Average column.

[#3]

Hi Archie,

In "Expression" tab (properties), you can either check :

- total (which execute expression)

- average

best regards

Chris