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?
Hi @Xiaorui
Can you share sample data/screenshot of your formula? I can't reproduce:
@Xiaorui
It works for me.
Try by keeping the field in numeric type and tell us if the issue persues.
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.
@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.
@Xiaorui ,
Maybe your input was .107?
Cheers,
Mark
