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)
POYP | Alteryx Result | Expected Result |
608.355 | 608.35 | 608.36 |
608.35 | 608.35 | 608.35 |
608.3546 | 608.35 | 608.35 |
608.356 | 608.36 | 608.36 |
6089.35 | 6089.35 | 6089.35 |
Please help me to fix the issue
Regards,
Alwin
I used this expression in a Formula tool: Round([POYP], .01) and matched your expected results.