Solved

formula to round number

Posted on 2006-10-26
12
739 Views
Last Modified: 2012-05-05
Hi
 I am using the following to convert to get rounded numbers in my stored procedure. How can I do the same in crystal report editor and what is the formula for the same. How do you get to the editor

convert(int, round(convert(float,@number)/1000, 0)
0
Comment
Question by:PNKJ
  • 4
  • 3
  • 2
  • +1
12 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 17812971
Hi PNKJ,
On the face of it, all you need is a formula field with:

Round(@number/1000,0)

Pete
0
 

Author Comment

by:PNKJ
ID: 17812997
Thanks but where do you write this formula I am trying to click on the column field and format not sure if i am right
0
 
LVL 77

Accepted Solution

by:
peter57r earned 250 total points
ID: 17813094
You have to create a new Formula Field in the field explorer.

When you have done that you drag the formula field into the report.

Pete
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 
LVL 100

Expert Comment

by:mlmcc
ID: 17813146
A little help with creating a formula

Display the field insertion popup
Click the FORMULA Tab
Click NEW (may have to right click)
Name - MyRoundedNumber
Formula
As Above

Click SAVE
Close the formula editor

Drag the formula onto the report and delete your other field

mlmcc
0
 

Author Comment

by:PNKJ
ID: 17813196
Whenever i try to save it says ) is missing there is error in formula i wen tto feild explorer right click formula fields
Selected new gave the name and the formula editor opened .
I typed Round(@number/1000,0)
when trying to save it gices error ) is missing
0
 
LVL 77

Expert Comment

by:peter57r
ID: 17813227
What is @number?
0
 

Author Comment

by:PNKJ
ID: 17813263
From data table i have meatproducts, groceries etc these are the colomn names and are returned as such from database for eg datatable_meatproducts
0
 

Author Comment

by:PNKJ
ID: 17813790
I wrote this in formula editor and i get error boolean is required
If {datatable.section} = 1 or Trim({data_table.section_name}) = "yearly report" then
Round({datatable.meatproducts}/1000,0)and
Round({datatable.vegetables}/1000,0)
0
 
LVL 13

Expert Comment

by:crgary_tx
ID: 17813944
it is 'and' or 'else you are using in the formula? Replace 'and' with 'else' if you are using 'and' in the formula

Gary
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 17814011
If @number is another formula it needs to be in { }

IN your record do you have several numeric values you want rounded?  If so you will need to have a formula for each

For example to get the meat products
If {datatable.section} = 1 or Trim({data_table.section_name}) = "yearly report" then
   Round({datatable.meatproducts}/1000,0)
else
   {datatable.meatproducts}            

for the else part use whatever value you need if it isn't section 1 or the yearly report

mlmcc
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

821 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