ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors