calculate the avarage base a column

[lukeert19]

Hello to all

Hoe can calculate the average for each partcode base on PartL3 column?

axample in attached 🙂

thanks to all

🙂

[marcohadiyanto]

Hi

Try this one

Sum(Pcs)/sum(total <PartL3> Pcs)

Regards

[lukeert19]

thanks for replay @marcohadiyanto 

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

[sunny_talwar · Accepted solution]

@lukeert19 just change Sums to Counts

Count(pcs)/Count(TOTAL <PartL3> pcs)

[lukeert19]

hello @sunny_talwar and @marcohadiyanto   thanks a lot for your time.

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?

[sunny_talwar]

@lukeert19 May be this

Count(TOTAL <PartNumber> PartNumber)

[lukeert19]

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 😞

[sunny_talwar · Accepted solution]

@lukeert19 May be this

Count(DISTINCT TOTAL <PartNumber> PartNumber)