Dynamic decimal point based on other column field value

Dear Expert,

I need support to design the workflow for a business case where decimal point needs to be adjusted based on the value given in next column. Here in given data set 1st column "Value" hold the original value and in 2nd column we have decimal point value which will be used to adjust the column 1 value. In 3rd row we have the adjusted data according to decimal point value.

In case if rounding is required we need to do a round up. I am wondering how to design the workflow for this use case. Could you Pls guid.

Value	Decimal point	new value after decimal adjustment	remark
1.356	2	1.36	rounded up
0.00356	3	0.004	rounded up
0.2	4	0.2000	added only zeros
0.4567	5	0.45670	added only zero

Alteryx Editions

Accepted answers

binu_acs

@akhukla use toString function

All comments

OTrieger

@akhukla
You can out the number of decimal characters and if bigger than the value in decimal point round up the number. For adding zeros that would work only if the field will be string, you cannot add zeros to a numeric field, but you do able to define how many decimal places you will have, but it means that if you have 5 decimal places it will be for all the cells, therefore you will need to go with string data type to get the desired result

OTrieger

With IF statement or ELSEIF you can set all the needed conditions for the rounding or adding zeros

binu_acs

@akhukla use toString function

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335