Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Khanyie_
Contributor
Contributor

Average Cost per Unit

Good day

I'm trying to calculate: Stock On Hand per item  * Average cost per unit.

I Have the following:

avg(aggr(sum([AverageCost]),(STOCK_ON_HAND))) 

It's not giving right value. Is there anyway of getting an average either by using aggr function or a different way?

 

0 Replies