formula to round number

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)
PNKJAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
peter57rConnect With a Mentor Commented:
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
 
peter57rCommented:
Hi PNKJ,
On the face of it, all you need is a formula field with:

Round(@number/1000,0)

Pete
0
 
PNKJAuthor Commented:
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
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.

 
mlmccCommented:
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
 
PNKJAuthor Commented:
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
 
peter57rCommented:
What is @number?
0
 
PNKJAuthor Commented:
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
 
PNKJAuthor Commented:
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
 
crgary_txCommented:
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
 
mlmccConnect With a Mentor Commented:
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
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.