Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards!

Solved!
Level 2

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.

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.

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