Divide a column by another one

Stan75

Hi,

I am supposed to get the GDP per capita.

I have a column GDP and a column population.

How I can divide GDP by population ?

JuanE

You can do this in a formula processor inside a Prepare recipe:

https://knowledge.dataiku.com/latest/data-preparation/prepare-recipe/concept-prepare-recipe.html

I suggest that you go through our Academy courses:

https://academy.dataiku.com/

Abdoulaye

Create a recipe of type formula then devide columnA/ColumnB. 

Sze Zhong

I am having the same issue. Even if i try columnA/columnB, i am getting tnothing. but if i do columnA +500 i get something.

Sze Zhong

https://community.dataiku.com/discussion/comment/45763#Comment_45763

To be specific:

numval("Oil production (Etemad & Luciana) (terawatt-hours)") works.

numval("Oil production (Etemad & Luciana) (terawatt-hours)") +200 works.

numval("Oil production (Etemad & Luciana) (terawatt-hours)") /20000000 works.

numval("Oil production (Etemad & Luciana) (terawatt-hours)") /numval(u_Year) doesnt work. Even when i put u_Year as an integer.

numval("Oil production (Etemad & Luciana) (terawatt-hours)") /numval(u_Population) doesnt work. Even if both are double.