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
Solved! Go to Solution.
Does using the second argument to specify the number of decimal places in ToString(x, numDec) solve this issue?
I am not sure what is causing this error, but I would round the numbers as a final step after all calculations are done.
This might resolve the issue you are having.
It didnt work. I have also uploaded the workflow for your reference
@Emmanuel_G wrote:Hi @madhurinani
Do you want something like this ?
It didnt work. I have also uploaded the workflow for your reference
Don't change the data type in the select for the percentages. Instead create a new field in the Formula Tool where you convert the numerical value to a string. Something like,
ToString([PQ FD %], 2)+'%'