How to add a + or - sign before percent?

[jip31]

hi

i add a + or a - sign before a percent result like this

| eval perc=if(s<2,"-","+").round((s/2)*100,1). "% " 

 But I need to substract 100 to the percentage result like below

| eval perc=if(sam<sam2,"-","+").round(100-(sam/sam2)*100,1). "% " 

but when I do this, I have + and - before the percent result

how to avoid this please?

[isoutamo · Accepted solution]

You can use function abs like

| eval perc=if(sam<sam2,"-","+").abs(round(100-(sam/sam2)*100,1)). "% " 

r. Ismo