Multi Field Rounding of numbers in a string format

[Mario36]

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.

[alexnajm · Accepted solution]

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