Multiplying large numbers

[gj0519]

I have 2 formulas that I am multiplying, 1st formula is 6 digits, and 2nd formula is 14 digits. My result shows up as 9.61e+019. I need the result to be the whole number.
Any ideas.

Thanks,

Glenn

 

[elsenorjose]

Hi Glenn,

As a long time member (if not necessarily contributor) in the forum, I can tell you that the members will be able to help a lot more if you provide more information. Where are you placing the formula? What version of Crystal Reports are you using? What database system are you using?

The more information you can provide about your problem the greater the odds of having one of the members provide you with valuable information.

Thanks.

 

[gj0519]

Using version 9.0 pro
pulling from DB2
All together I have 4 formulas.
1st formula gives me the ordinal date:

ToText(year(today),0,"") & ToText(datediff("d",date(year(today),1,1),today),0,"")

2nd is just a value:

NumberVar Key:= 5;
Totext(key,0,"")

3rd is my 14 digit number:

Left({@Diff#},14)

Final to give me my answer: I don't get the whole number when I mulitply Digits.

NumberVar Ord:= ToNumber({@OrdDate});
NumberVar Key:= ToNumber({@KeyValue});
NumberVar Digits:= ToNumber({@14Digits});

((Ord - Key) * Digits)

Hope that explains it better.
Thanks,
Glenn