Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirsten
Creator II
Creator II

Average costs per system

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

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

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)])

View solution in original post

2 Replies
jwjackso
Specialist III
Specialist III

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
Creator II
Creator II
Author

It works thanks!