Query about the formula

Solved!
MS_Latha
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

0 Kudos
1 Solution
MiguelangelC
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

 

View solution in original post

0 Kudos
4 Replies
MiguelangelC
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

 

0 Kudos
MS_Latha
Level 2
Author

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

CoreyS
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!
0 Kudos
MSL
Level 2

Thank you very much ๐Ÿ˜Š 

0 Kudos