Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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