Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this: Full Cost / sum(TOTAL Full Cost) This will be Average column.
Hi Archie,
In "Expression" tab (properties), you can either check :
- total (which execute expression)
- average
best regards
Chris