# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for
Did you mean:
Contributor III

## calculate the avarage base a column

Hello to all

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

axample in attached 🙂

thanks to all

🙂

2 Solutions

Accepted Solutions
MVP

@lukeert19 just change Sums to Counts

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

MVP

@lukeert19 May be this

``Count(DISTINCT TOTAL <PartNumber> PartNumber)``
7 Replies
Partner - Specialist

Hi

Try this one

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

Regards

Contributor III
Author

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

MVP

@lukeert19 just change Sums to Counts

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

Contributor III
Author

hello @sunny_talwar and @chooco_co   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?

MVP

@lukeert19 May be this

``Count(TOTAL <PartNumber> PartNumber)``
Contributor III
Author

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 😞

MVP

@lukeert19 May be this

``Count(DISTINCT TOTAL <PartNumber> PartNumber)``