Ready for Dataiku 9? Try out the Crash Course on new features! GET STARTED

Scientific Notation not removed by format() function

Joeiku
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,

Joe

0 Kudos
1 Reply
Makoto
Dataiker
Dataiker

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,

Makoto

A banner prompting to get Dataiku DSS