How can I make the value in a calculated field round to nearest even number

Siddhartha · February 10, 2021, 3:36pm

I have a field that contains an integer, but I need it to always be an even number, and rounded down if necessary.

So 19 would become 18 for example
37 would become 36, etc.

Any ideas would be much appreciated.

boston85719 · February 10, 2021, 3:51pm

Just wondering why rounding down is necessary?

Siddhartha · February 10, 2021, 4:00pm

It is relating to investments, and so the resulting number (which is to do with shares) needs to be below, otherwise they’d max out on the amount of shares bought.

mikeloc · February 10, 2021, 4:08pm

Hi there, @Siddhartha… I believe you could use the <-modulo-> function to accomplish this task. If you do integer<-modulo->2, you will get a result of 0 or 1, and then you can subtract that number from the initial integer.

Hope this helps.

Best…
Mike

adamhholmes · February 10, 2021, 4:08pm

number/2:floor *2

Siddhartha · February 10, 2021, 7:05pm

Thanks Mike. Much appreciated.

Siddhartha · February 10, 2021, 7:06pm

Thanks Adam. Much appreciated. I now have two solutions. You guys are the best.

system · April 21, 2021, 3:36pm

This topic was automatically closed after 70 days. New replies are no longer allowed.