Multi Field Rounding of numbers in a string format

On the below data, columns 1991 and 1992 are V_WString type and Decimal Places is Int32, I am looking to add a MultiField Tool to round the columns based on the Decimal Places column. However I get the rounding which is not as expected. Also, please note that any null or blank columns in 1991 and 1992 should return null instead of 0.

Developer

Accepted answers

alexnajm

The second part of the rounding is not the number of decimal places, you should type 0.01 for your Round function: https://help.alteryx.com/current/en/designer/functions/math-functions.html#id605331

All comments

alexnajm

The second part of the rounding is not the number of decimal places, you should type 0.01 for your Round function: https://help.alteryx.com/current/en/designer/functions/math-functions.html#id605331

dreldrel

Yes, @alexnajm is correct. Alteryx uses a different method to configure decimals. Another way to define it in the Select tool is by using the format [Length for Integer].[Decimal]. For example, 19.2 means you will have 19 digits for the integer part and 2 digits for the decimal part.

Mario36

@alexnajm and @dreldrel
I realized that and it worked, however if I have numbers in int32 type, example: 2,4,5 etc. for 2 decimals, I want the number to display 2.00,4.00,5.00 instead of just 2,4,5

alexnajm

Then you'll have to do that in your Excel, or you can set the data to a string and use a ToString() function to set your number of decimals

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703