I have data in the following format.
Value should be in Gb
I have a few values that were improperly entered as Mb like below
I would like to see if it is possible to do an eval to detect any value over 1024 and divide it by 1024 to convert it to Gb.
I have tried the below and it did not work.
| eval MemoryCount=if(MemoryCount>1000, MemoryCount/1024)
Is there any way of accomplishing this?