Rounding issue

I am trying to multiple a field. It's value is 0.0004932 in a formula, Crystal Reports keeps rounding that value to 0. If I do ToText(myfield, 10) It doesn't allow me to multiple the result as it is now a string. Can someone please help ? All I want to do is just multiple the original value of 0.0004932 within a formula without Crystal Reports converting.
mowitAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
I agree with the above comment.  The values are saved but when you display them they may get rounded.  

Are you displaying the field on the report?
Did you formt it for more than 4 decimal places?
Did you set the rounding so it rounds at 5 decimals or more?

Right click the field.
You should see a NUMBER tab as the displayed tab.
If you don't then it is not a number
If you do select the appropriate format or choose custom to set the appropriate format.

Try using a fixed formula like
10000 * {@YourFormula}

mlmcc
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I presume that this page will help:
http://crystaltricks.com/wordpress/?p=163
0
 
mowitAuthor Commented:
AnelIII, I need to do this in a formula, therefore this link doesn't help.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
a formula will retain the data type precisions used, so you need to make sure your input variables are indeed decimal.
other than that, it's only display format issues.
0
 
mowitAuthor Commented:
Crystal shows the field is of datatype number.
0
 
mowitAuthor Commented:
Just looked at the XSD and the field is listed as decimal.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.