Creating a new column in table with Div formula

[Anonymous]

Hi All,

this is my first post in the Qlik community. I've recently started using QlikSense for work purpose. However, i cant seem to figure out how do i add 1 more column in the table with a formula.  As shown below, i would require a new column that divides Total Sales by Quantity sold. 

Total Sales (column 1) -------------Quantity (column 2) -----  Price per piece (column 3)

The Div function is not working as it should. Kindly advice.

Thanks!

[tresesco]

Are you trying to create this new column in the UI or script? Could you share a sample app explaining the expected output? 

[Anonymous]

Hi,

I'm trying to create it though UI. any suggestions?

R12 desired output should be 23.55

Thanks

[tresesco]

What are formulas you are using for all three columns?