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