Query about the formula

MS_Latha

Hi experts, I am working on the core designer certification.

I have one of the tasks to calculate the percapita. To convert from country “total” data to “per-capita” data divide by the country's population. I am using this formula

numval(" Oil production (Etemad & Luciana) (terawatt-hours)") / numval("population")

but after applying this formula I am getting an empty output column. Guide me to get through this .

thankyou

Miguel Angel

Hi,

This corresponds to step 5 of the certificate's instructions. In this step there is also a hint that tells us how to solve this problem:

Hint 2: The Formula page in the reference documentation shows the proper syntax for using formulas to read column values when the column names include spaces.

The link brings you here: https://doc.dataiku.com/dss/latest/formula/index.html#reading-column-values

MS_Latha

Thank you so much for the guidance. I successfully completed my core designer certification.

CoreyS

Congratulations @MS_Latha
!

M S

Thank you very much