Average costs per system

[Kirsten]

I would like to have average costs per system, and I used this formula:

 Sum([Total Cost])/Count([Product Description (SAP)])

Product Description (SAP) represent the system name.

But I think the formula is wrong because I get almost the same amount as the Total Cost graph

See attachment

[jwjackso · Accepted solution]

Add a TOTAL to the count, otherwise I think it is only return a 1 for each [Product Description (SAP)]

Sum([Total Cost])/Count(TOTAL [Product Description (SAP)])

[Kirsten]

It works thanks!