topic Calculate the Quote conversion Rate in App Development https://community.qlik.com/t5/App-Development/Calculate-the-Quote-conversion-Rate/m-p/1682760#M51976 <P>Good morning.&nbsp;</P><P>I would like to calculate the % is accepted Quote items against the items in a Quote. This will be against a Customer and / or Product code. Looking at the snippet, the top Table uses the Cyclic dimension, the middle Table is by Product and the bottom Table is by Customer.&nbsp;</P><P>In the top Table (Cyclic Table), I am using Avg instead of Auto. The last column is set to Auto. The question is that I am expecting the total in the "Quoted / Picked hit Rate" to also be at 80% instead of 83.33%.&nbsp;</P><P>I also attach the App so you can see the expression.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 949px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29740i70B6D6C7C2F90116/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>Thank you in advance.&nbsp;</P> Mon, 20 Dec 2021 21:32:42 GMT johngouws 2021-12-20T21:32:42Z Calculate the Quote conversion Rate https://community.qlik.com/t5/App-Development/Calculate-the-Quote-conversion-Rate/m-p/1682760#M51976 <P>Good morning.&nbsp;</P><P>I would like to calculate the % is accepted Quote items against the items in a Quote. This will be against a Customer and / or Product code. Looking at the snippet, the top Table uses the Cyclic dimension, the middle Table is by Product and the bottom Table is by Customer.&nbsp;</P><P>In the top Table (Cyclic Table), I am using Avg instead of Auto. The last column is set to Auto. The question is that I am expecting the total in the "Quoted / Picked hit Rate" to also be at 80% instead of 83.33%.&nbsp;</P><P>I also attach the App so you can see the expression.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 949px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29740i70B6D6C7C2F90116/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>Thank you in advance.&nbsp;</P> Mon, 20 Dec 2021 21:32:42 GMT https://community.qlik.com/t5/App-Development/Calculate-the-Quote-conversion-Rate/m-p/1682760#M51976 johngouws 2021-12-20T21:32:42Z