How to use plus sign before a result to calculate percentage?

[jip31]

Hello
I use the eval below in order to calculate a percentage

| eval Trend_Proc_time=round(100-(Proc_dest*100)/(Proc_source),1)." %" 

When Proc_dest is > to Proc_source I have a result with minus - perfect
But when Proc_dest is < to Proc_source, I need to have a + sign before the result
could you help me to do this please?

[nickhills · Accepted solution]

Hi.
Using regex/sed you could try this

...| eval Trend_Proc_time=round(100-(Proc_dest*100)/(Proc_source),1)." %" 
   |rex mode=sed field=Trend_Proc_time "s/^(\d+)/+\1/"

[jip31]

perfect thanks

[vnravikumar]

Hi

Try like

your query| eval Trend_Proc_time=round(100-(Proc_dest*100)/(Proc_source),1) 
    | eval Trend_Proc_time=if(Trend_Proc_time>0,"+".Trend_Proc_time." %",Trend_Proc_time." %")

[jip31]

sorry it doesnt works