Problem of Average Total%

[tracycrown]

Dear all

Kindly advise why the average total% cannot be computed as 20%, 16.7% is wrong.

Thank you, Tracy

[rubenmarin · Accepted solution]

Hi, you can ignore factories without rental adding the condition:

Avg({<Factory={"=Sum([Rental])<>0"}>} Aggr(Sum([Rental]/Sum(total Rental)), Factory))

Avg({<Factory={"=Sum([Rental])<>0"}>} TOTAL Aggr(Sum([Rental]/Sum(total Rental)), Factory))

[tracycrown]

Dear Mr Rubenmarin

Thank you very much for advising such an excellent method which helps to solve many current issues still have not posted yet. You are so knowledgeable and experienced in Qlik, hope to learn from you more in future.

Many Thanks , Tracy