Query about the formula
![MS_Latha](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar1.png)
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
Best Answer
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 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
Answers
-
MS_Latha Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 8 Partner
Thank you so much for the guidance. I successfully completed my core designer certification.
-
Thank you very much