manipulation of the value

Hi!
here the value of the data
image
do you know how to manipulate the value to be consistent like this;
115
104
95
87

best regards,
putri

Hi @veni_agustina , welcome to the KNIME community.

Can you please expand on what you are trying to do, and what you mean by “consistent”.

If I were doing this as an IQ test :wink: , I’d say that you are trying to return just the “millions” values as an integer, for each of the values stated.

Is that what you mean? If so, try this in Math Formula

floor($MyValue$/1e6)

2 Likes

thank you so much, @takbb You help out me a lot

1 Like

You’re welcome @veni_agustina , and thank you for confirming the solution.

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