round a number to its nearest multiple of one hundred

KNIME Analytics Platform
1

Hello everyone. I open this forum because I have this question of How to use the math formula node for round Numbers to de nearest multiple of one hundred. Example: If I have 550 that number needs to be un 600, but if I have 520 that number needs to put in 500.

2

Hi @britneyg12

Welcome to the KNIME Community!

You can use round($column1$ / 100) * 100 for this.

image
image1287×711 31.2 KB

6 Likes
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.