Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

Alteryx Designer Desktop Discussions

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

Rounding the value

allwynbazil
8 - Asteroid

Team, I have numbers in a column with more than two decimal places. If a value has only two decimals, it should remain unchanged. However, if it has more than two, it should be rounded based on the third decimal. I tried using the round formula, but it isn't producing the desired results

 

Round([POYP], 0.01)

 

POYPAlteryx ResultExpected Result
608.355608.35608.36
608.35608.35608.35
608.3546608.35608.35
608.356608.36608.36
6089.356089.356089.35

 

Please help me to fix the issue

Regards,

Alwin

1 REPLY 1
Prometheus
12 - Quasar

I used this expression in a Formula tool: Round([POYP], .01) and matched your expected results.

Rounding.PNG

Labels