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