https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845312#M69935 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/69451">@andrewc</a>&nbsp;,</P><P>&nbsp;</P><P>Please try</P><P>Column(1)-Column(2)</P><P>1 and 2 would be your column position in the table.</P> Tue, 12 Oct 2021 07:56:46 GMT abhijitnalekar 2021-10-12T07:56:46Z https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845299#M69934 <P>I am sorry, this should be basic stuff!</P><P>Looking at the below I am wanting to create a new column [TOTAL WORKLOAD] / [DISTINCT OPERATORS]&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="andrewc_0-1634023599541.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/63955iEFC0E86809BE92CA/image-size/medium?v=v2&amp;px=400" role="button" title="andrewc_0-1634023599541.png" alt="andrewc_0-1634023599541.png" /></span></P><P>Formula's for each below:</P><P>[DISTINCT OPERATORS] = count(distinct OPERATORID)</P><P>[TOTAL WORKLOAD] = sum(WORKLOAD)</P><P>&nbsp;</P><P>I was hoping this would work, but nup ...</P><P>sum(WORKLOAD) / count(TOTAL &lt;DATE&gt; distinct OPERATORID)</P><P>&nbsp;</P><P>The first result should be ~5,955</P><P>Thanks!</P> Tue, 12 Oct 2021 07:30:52 GMT https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845299#M69934 andrewc 2021-10-12T07:30:52Z https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845312#M69935 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/69451">@andrewc</a>&nbsp;,</P><P>&nbsp;</P><P>Please try</P><P>Column(1)-Column(2)</P><P>1 and 2 would be your column position in the table.</P> Tue, 12 Oct 2021 07:56:46 GMT https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845312#M69935 abhijitnalekar 2021-10-12T07:56:46Z https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845343#M69938 <P>Why not just sum(WORKLOAD) / count(distinct OPERATORID) ?</P> Tue, 12 Oct 2021 08:35:32 GMT https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845343#M69938 Or 2021-10-12T08:35:32Z https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845830#M69972 <P>Uuurgh! I should have started with simple! Thanks Or!&nbsp;</P> Tue, 12 Oct 2021 22:17:54 GMT https://community.qlik.com/t5/App-Development/Qlik-Table-Distinct-Total-Percentage/m-p/1845830#M69972 andrewc 2021-10-12T22:17:54Z