New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

There seems to be no currency field type. So when grouping rows with $ the Sum operator isn't available.

UserBird
Dataiker
Dataiker
There seems to be no currency field type. So when grouping rows with $ the Sum operator isn't available.
 
0 Kudos
1 Reply
kmuehmel
Dataiker
Dataiker

If there is non-numerical character in the data, it's being stored as a string, whereas only integers (or floating point numbers) can be summed. 



To sum the data, you will need to:




  1. Create a preparation script

  2. Find and remove (i.e. replace with nothing) the dollar signs. Depending on exactly what is in the data, the "Extract number" processor may save a few clicks.

  3. Change the "Store as" to "Integer" by clicking on the column header.



Of course, the final output will no longer have dollar signs, but you can indicate the unit in the column header.

Kurt
Chief Customer Officer @ Dataiku
0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS