Like I said, I should be able to use that in oter calculations. I don't think the one above you provided can be used.
Other calculations I am trying are.
- Total cost of the zero products (each product has different price)
- % of total of Zero products
- pareto of Zero products
I think becasue it is already an aggregated value, I am unable to use it for price calculations and the % of total calculated table down is giving wrong result.