Hello All,
I am facing an 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
