topic Average costs per system in QlikView

Average costs per system

Kirsten — Thu, 13 Aug 2020 21:04:57 GMT

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 — Thu, 13 Aug 2020 21:38:01 GMT

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 — Thu, 13 Aug 2020 21:46:16 GMT

It works thanks!