Convert num not working

[venanciop]

Convert does not work

search | convert num(quantity) as Quantity

The quantity field samples are: 1.0000
2.0000
9.0000
7.0000

[tzitello_splunk]

When I run convert on a field name, it does not convert the new field to numeric, it's alpha numeric. I'm running V 7.2.1

search| convert num(Samples.Sample.Depth) as meters

meters shows up with a instead of #. Suggestions?

[koshyk]

When you say it is NOT working, i'm not sure I understand. You provided quantity already as a number, so you won't see the difference

Try below to see the difference. You can see rounding works , sum works etc.

|makeresults | eval quantity="1.0000" | convert num(quantity) as Quantity| eval Quantity=round(Quantity,2)| eval sumQuantity=(1 + Quantity)

[DalJeanis]

Change that to | eval quantity="1.0000 " (non numeric) if you want to demonstrate any difference.