Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

Scientific Notation not removed by format() function

Level 2
Scientific Notation not removed by format() function

Hi there, 

I currently have a value in one of my columns which reads: -2.1884462822743185E7

I am trying to get it into the format: -21884462.82

I have seen that I'm not the only user to have this problem, and other users have been recommended to use the formula: 

format("%.2f", your_column_name)

However, this only works in the sample output next to the formula box, and not in the actual output. 

Any Ideas?

Kind regards,


0 Kudos
1 Reply

Hello Joe, 


By default, DSS will display numbers in scientific notation above a certain threshold and unfortunately this is not configurable. 

If you do need to keep the value, your workaround would be to multiply this column by 10 and apply the formula below(3f instead of 2f).

format("%.3f", your_column_name)


Screenshot 2020-11-23 at 13.30.27.png




Instead of applying formula, you can also use round number processor in the Prepare recipe.

Another (less recommended than above) workaround would be to store this column in a string format. 

Best regards,


A banner prompting to get Dataiku DSS