Basic Conversion (KB - GB) Formula Query *Solved*

[Former Member]

Post Author: Miles

CA Forum: Formula

Hey guys,

I am creating a custom report. Within this i have users and their home drives. I have set it up with depth and size, now for convince instead of having it all in the default of KB id like to have under it a total usage in GB (1048576 KBs)

I have done some basic programming some time ago but this has go me stumped.

I always get some form of problem.

Something on the lines of ...

If

sum = ({Data.SizeUsed}) \ 1048576 then =

Anybody have any ideas?

Thanks, Miles

[Former Member]

Post Author: V361

CA Forum: Formula

You could just use CR instead of basic

Say call the formula @GIG

{data.size} / 1048576

so if your data size was 77089021952 your formula would divide that by 1048576 and give you 73517.82031 as a result. You could then round that up to the correct number. APX 73 gig