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

Ended up fixing it, basic problem. Refer to this if you can apply it to your problem

If Sum({Data.SizeUsed}) > 0Then Size:= Sum ({Data.SizeUsed}) / 1048576 ;

Basic yes i know.

[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

[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