https://community.qlik.com/t5/Data-Movement-Streaming/Division-of-two-columns/m-p/2493881#M2845 <P>Hi,</P> <P>Put like this, Sum(<SPAN>quantity</SPAN>)/Sum(sales) as&nbsp;<SPAN>unit_price&nbsp;</SPAN></P> Thu, 21 Nov 2024 10:00:25 GMT Muthukumar_77 2024-11-21T10:00:25Z https://community.qlik.com/t5/Data-Movement-Streaming/Division-of-two-columns/m-p/2493840#M2843 <P>Hello,</P> <P>I need to divide two different column values: quantity and sales and make a new column of unit_price. When I do this: quantity/sales I get an empty unit_price column. What should I do?</P> Wed, 19 Mar 2025 21:46:28 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Division-of-two-columns/m-p/2493840#M2843 liucia_liucia 2025-03-19T21:46:28Z https://community.qlik.com/t5/Data-Movement-Streaming/Division-of-two-columns/m-p/2493877#M2844 <P>Hi,&nbsp;</P> <P>You need to aggregate it like sum(sales/quantity) as unit_price</P> <P>Best</P> Thu, 21 Nov 2024 09:49:28 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Division-of-two-columns/m-p/2493877#M2844 mpc 2024-11-21T09:49:28Z https://community.qlik.com/t5/Data-Movement-Streaming/Division-of-two-columns/m-p/2493881#M2845 <P>Hi,</P> <P>Put like this, Sum(<SPAN>quantity</SPAN>)/Sum(sales) as&nbsp;<SPAN>unit_price&nbsp;</SPAN></P> Thu, 21 Nov 2024 10:00:25 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Division-of-two-columns/m-p/2493881#M2845 Muthukumar_77 2024-11-21T10:00:25Z