Round Formula

[Xiaorui]

when I use round formula, Round( [column], 1), why there are some cells get the wrong results? I have a number, 1.07, the result should be 1, but I got a 0. 

Could anyone explain why this happened and how to solve it please?

[Luke_C]

Hi @Xiaorui 

Can you share sample data/screenshot of your formula? I can't reproduce:

[Emmanuel_G]

@Xiaorui 

It works for me.

Try by keeping the field in numeric type and tell us if the issue persues.

[Xiaorui]

Hi @Luke_C ,

When I import this data, the result is round correctly, but when I export as report, the number change to 0 and I don't know why.

[Luke_C]

@Xiaorui Please share more details, a simplified version of your workflow or even screenshots of the tools/configurations will be helpful. Otherwise it's very tough to pinpoint your issue.

[MarqueeCrew]

@Xiaorui ,

Maybe your input was .107?

Cheers,

Mark