Error: Decimal place issue when converting Double to String to add '%' symbol suffix

Question

Hello,

Below are the requirements:

I need to substract 2 percentage columns (current FD Own %) and (pq) column and find out the difference and then add the % symbol to display as a percentage substraction.

I was able to do that and create a new column= Change.

Now to add the % symbol at the end, i belive i need to convert the Double data type into a string and use the TOSTRING function to add that symbol.

When I add that I see that my 2 decimal places are now becoming like 10,12.

Can anyone help me in that?

The highlighted part of the screenshot is where I see the issue.

I have also attached with workflow file.

2022-07-04_16-38-14.png

demo.yxmd

madhurinani · Answer

@calebdugger : I tried your logic and its not working. My data type is DOUBLE and I used your formula to convert into a STRING. It shows a Parse Error at char error.

I tried both ways, adding a new column as well as editing the same column.

calebdugger · Answer

I don't believe there is any reason to add the "Select" tool as that's not how you'd want to change it to a String field. I had a similar scenario just today.

The field was numeric, but I wanted to change to a string so I could add a '%' to the end.

I tried the first screenshot first and it wouldn't work because the "Data type" was still a numeric type, but you can update it right on the "Formula" tool as you see in the second screenshot.

As you can see, it worked like I wanted it to after that. Hopefully this helps!

#1 = Showed an Error

#2 = Worked great!

madhurinani · Answer

Hello All,

I am still facing the error as noticed by the client recently.

Step 1: I have created a new category column which is an nested if-else condition. Hence all the columns are in DOUBLE format. Works fine as expected.

Step 2: I convert the 3 columns in STRING as I need to append % symbol. (image attached)

Step 3: I create 3 formulas to append the %symbol for all the columns.

Problem: When I use the step 2 SELECT logic to convert the from DOUBLE to STRING, my values in the Change column change.

Attached pics.

How Can i resolve this issue. Any help would be appreciated.
Ideally the value should be 0.08% only

Thanks.

2022-07-12_11-27-09.png

2022-07-12_10-48-06.png

2022-07-12_11-24-02.png

2022-07-12_11-24-59.png

2022-07-12_11-25-57.png