Values needed to be printed only in MB

[rkumar23]

I have values in bytes which are being read and then using the MGBYTES. format or SIZEKMG. format printed now problem is there are some small values being calculated in Bytes/KB while others are large enough to make GB however requirement is irrespective of Bytes/KB  or GB have them printed only in the "MB" format...so for example below ...

1316M	1
	0:00				No Limit	296K	0
	0:30	????????			3200M	27G	31
	0:45				No Limit	1129M	1
	0:45		bbbbbbb	ffsfgsdfg	300M	30G

Anybody got idea how do i make sure these all only printed in MB so for example 0:00 value 296K should be printed as 0.28MB while 27GB should be printed as 27567MB ...

These all values are initially in bytes...

[Reeza · Accepted solution]

Create your own format, 1024 bytes in 1kb and 1024kb is 1MB

So your initial value divided by 1024*1024 then format either manually or via custom format.

want=cat(put(value/(1024**2), 8.2 -l), "MB");