thanks for replay @chooco_co
my mistake sorry, I can't use sum() function because PCS column is a formule --> count(pcs) and I can't put this formula into sum(count(pcs)) 😞
by using the formula above is possible to calculate the avg based on PartlL3 field that it's good, fist report done, thanks a lot again
I have only last question about other similar report, I have attached a picure where in table I have 3 calculated columns
coloumn: qty consumed --> done with Count(pcs)
total P/N repaired: based on teh first column [partNumber] how can show the result like in the picture?
avg column based on qty consumed and total P/N Repaired -->how can calculate the result like in the picture?
hello @sunny_talwar I have already tried but the number shown from qlik isn't real, I need to use one formula like below
Count(distinct <ID> PartNumber)
but I don't know how I can correct this formula 😞