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?
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/"
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/"
perfect thanks
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." %")
sorry it doesnt works