asked on

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)

peter57r

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

Round(@number/1000,0)

Pete

PNKJ

ASKER

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

ASKER CERTIFIED SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

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

PNKJ

ASKER

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

peter57r

What is @number?

PNKJ

ASKER

From data table i have meatproducts, groceries etc these are the colomn names and are returned as such from database for eg datatable_meatproducts

PNKJ

ASKER

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)

crgary_tx

it is 'and' or 'else you are using in the formula? Replace 'and' with 'else' if you are using 'and' in the formula

Gary

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial