# Query about the formula

Solved!
Level 2
###### Query about the formula

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

1 Solution
Dataiker

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

4 Replies
Dataiker

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

Level 2
Author

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

Dataiker Alumni

Congratulations @MS_Latha

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as โAccepted Solutionโ to help others like you!
Level 2

Thank you very much ๐