Commas in Number format combined with Rounding in the Prepare Reciepe
I have a column of USD figures and I have used the Prepare recipe to do the following 2 functions:
1. Convert Number format from Raw to English
2. Round the values to 0 decimal places
The column is detected as a Double - Integer. before trying to do these 2 functions. It seems I cannot do these 2 functions together as converting the numbers causes the values to not be recognised as a Double. I have tried changing the Double to several other options but none of them help to fix the issue. additionally it is showing the figures with at least 10 decimal places .
For context I am trying to publish USD figures to a dashboard by adding comma and round to an integer so that it can be easily viewed by senior management
Best Answer
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,054 Neuron
The formatted number should only be used for presentation purposes, key the original column intact and create a new column for presentation while using the original column for calculations. For charts you have options to apply separate formatting to numbers, see:
https://doc.dataiku.com/dss/latest/visualization/formatting.html
Answers
-
Playing around with it further, it seems I can get it to have commas and also round it up in the Prepare recipe, but it turns it into a string so is not really helpful if I want to create charts for the dashboard out of it. Is there another way to make this possible?