Rounding half up

[Tienemientje]

Hi all,

Probably the easiest question ever on this community.  I found a number of similar cases, but not really a simple solution. Someone did mention the round half up or down setting that is used in Alteryx vs other tools, but not a solution for a workaround.

Is there a way to easily round 1.5 up to 2, while  1.44 must be rounded down to 1?

Round([number], 1) works for 1.56 (to become 2), but exactly the 0.5 is rounded down, while in many other programs it is rounded up.

CEIL([number]) rounds also 5.4 up to 6, while I want that to be rounded down.

Kind regards,

[afv2688 · Accepted solution]

Hello @Tienemientje,

You can do this easy by turning your column from double or fixed decimal to int using the select tool. This will automatically round the numbers as you want.

Regards

[Tienemientje]

Hi @afv2688 , I'm going accept that as a solution because I think it might help a lot of people.

It also works for me on a blank canvas, but somehow in my big workflow it does not work.

I have 2 similar sets of data with similar tools on my workflow and for 1 it works and for the other it doesn't.

So they both go into a "select" tool as double, with value of 100.5 (others in the same column are with more digits behind the comma, so that is also not the root cause)

I change the format in both select tools to INT64 and one comes out as 101 and the other as 100.

If I copy the cell values from the input of the select tool to an empty workflow, both turn to 101.

So somehow it seems that something upstream in the flow is causing this, but I can't figure out what.

For this flow, at that position (after all calculations and summaries are done), I can use a floor expression on both data sets and compare then if they match.  But I know that is not what I asked for (and not the ideal solution)...

A big thank you for your help!

Kind regards,

Tinne