Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Round Formula

Xiaorui
7 - Meteor

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?

5 REPLIES 5
Luke_C
17 - Castor

Hi @Xiaorui 

 

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

Luke_C_0-1665581554497.png

 

 

Emmanuel_G
13 - Pulsar

@Xiaorui 

 

It works for me.

 

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

 

Emmanuel_G_1-1665581933759.png

 

 

 

 

Xiaorui
7 - Meteor

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
17 - Castor

@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
20 - Arcturus
20 - Arcturus

@Xiaorui ,

 

Maybe your input was .107?

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels