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: Miles

CA Forum: Formula

Thanks V361

Somethings on the line of...

Shared StringVar DBSRealFormat ;Shared StringVar DBSIntFormat ;Shared NumberVar DBSRealRoundDigit ;Shared StringVar DBSSeperator ;Shared StringVar DBSDecimalPoint;

NumberVar Size:=0 ;

If Sum() > 0Then Sum ({Data.SizeUsed}) / 1048576