Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!

+1 vote

I have numbers like that in my dataset:

I want to concatenate them but using a normal decimal format such as 0.0008

How can I do that ? I know I can use Python but I'd prefer not to


1 Answer

+2 votes
Best answer


You can use the "format" function of the formula language.

This function takes a "printf format string" and applies it to any value.

In your specific case, if you want for example 5 decimal places, use:

format("%.5f", my_column_name)

Format strings are immensely powerful, they allow you to truncate strings, change precision, switch between numerical notations, left-pad strings, pad numbers with zeros, ...

More information about format strings:

DSS formula use the Java variant of format strings:

For more information about formulas, see:


selected by
1,337 questions
1,362 answers
11,912 users

©Dataiku 2012-2018 - Privacy Policy