Division of two columns

[liucia_liucia]

Hello,

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?

[mpc]

Hi, 

You need to aggregate it like sum(sales/quantity) as unit_price

Best

[Muthukumar_77]

Hi,

Put like this, Sum(quantity)/Sum(sales) as unit_price