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

+2 votes
Hello. I have numbers in a dataset that look like this: 1.6199999999999974

I want to reduce the precision to 3 decimal places. I saw there is a format function for strings, but didn't see anything similar for numbers. What is the best way to reduce the precision to 3 decimal places? Do I need to use a script for that? If so, can you help me with what it might look like?

Thanks for your help.
retagged by

1 Answer

+1 vote
Best answer


Use the "Formula" processor in data preparation, with a formula like:

format("%.3f", my_column_name)

DSS formula use the Java variant of format strings:

For more information about formulas, see:

selected by
It is helpful. Thanks Clement.
1,339 questions
1,365 answers
11,916 users

©Dataiku 2012-2018 - Privacy Policy