How to stop my workflow from rounding to the nearest tenth

[Lizbhernan]

I am currently working on a workflow and it keeps rounding to the nearest tenth. I tried adding a formula so it would round to 1 but it's not working.

And suggestions?

[DanM]

@Lizbhernan what data type are you using? Consider changing the data type.

[Lizbhernan]

@DanM I've changed it to Double, fixed decimal 19.2 and fixed decimal 19.1 but it's still rounding it :(

[DanM]

@Lizbhernan try using the FLOOR function. It would look something like FLOOR(4.567. 0.01) would return 4.56. I believe you could then add more zero's depending on how far past the decimal you want.

[Lizbhernan]

@DanM Am I able to use that for a column with different numbers or is that formula specific to specific numbers? 

[DanM]

@Lizbhernan there are different set ups for the FLOOR function depending on what you are attempting to do as you can see in the document https://help.alteryx.com/current/en/designer/functions/math-functions.html#example-6846016-11. If you scroll down to FLOOR you will see examples. FLOOR is not specific to any numbers it just depends on what you are trying to do.