Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

formula

Posted on 2011-03-03
4
Medium Priority
?
376 Views
Last Modified: 2012-05-11
Hi Guys,

I need a formula in CR to convert the below into 25.40

25400

Many thanks
0
Comment
Question by:mcse2007
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:LinInDenver
ID: 35032339
multiply the numeric field by 1000.

{fieldvalue} * 1000
0
 
LVL 7

Accepted Solution

by:
mcse2007 earned 0 total points
ID: 35032346
Shouldn't be

{fieldvalue} / 1000
0
 
LVL 14

Expert Comment

by:LinInDenver
ID: 35032467
Sorry yes, I read your question backwards. I read it as convert 25.40 into 25400.
0
 
LVL 7

Author Closing Comment

by:mcse2007
ID: 35067818
correct formula
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question