Can I stop SWQL from converting numbers into exponential values?

Question

I'm attempting to create some 30 day average widgets in the Modern Dashboard and I'm running into a snag. When attempting to do this with array size data SWQL is converting the calculated values to exponential values. I'm losing some of the value with this format and I'm also not sure how to properly convert it into KB, MB, GB, TB, etc from there. Any help would be appreciated.

KMSigma.SWI · Answer

I rather doubt any truncation you'll be doing will be affected - at least no more so than standard 1000 vs. 1024 conversion is concerned.

dkeyser · Answer

This was going into a Modern Dashboard with similar metrics. So I'm assuming it can't just keep the raw numbers in the output for my average then. Will that skew my results enough to matter?

KMSigma.SWI · Answer

Looks pretty solid.  Are you happy with the results?  Because if this is going into a report, you can just ask the report engine to convert the large exponential numbers of "byte" sizes.