Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
Kindly advise why the average total% cannot be computed as 20%, 16.7% is wrong.
Thank you, Tracy
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))
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))
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