rounding up in crystal 9

[wolverinec7]

anyone know how? you can in 11 using roundup which i what i'm using locally but the server we house our free enterprise software on uses V9 and i really need to round a formula up and this isn't recognised.

cheers

carl

 

[satinsilhouette]

try round that should be available in 9

Thanks so much!
satinsilhouette

 

[wolverinec7]

that just rounds up or down depending on the value.

i.e. 1.3 = 1
and 1.7 = 2

where i want both to return 2 as this is an order system so because we've used over 1 a week we need to see 2

 

[satinsilhouette]

Try Round({field},1)

Thanks so much!
satinsilhouette

 

[wolverinec7]

that just rounds it up or down to 1 decimal place

 

[dgillz]

Round({yourField}+.5,)

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[wolverinec7]

no that doesnt work either. the formula reads:

round({@max}-({STOCKM.PHYSICAL_QTY}+ STOCKM.MIN_STOCK_LEVEL})+.5,)

and its highlighting the +.5 part saying a boolean is expected here etc

 

[dgillz]

You need a '1' after adding the '+.5'

If you are still having a problem please shat what is in {@max} as well as any formulas that {@max} references.

Also please confirm that you have created a new formula field and you are not placing this formula in a record selection formula or any conditional format area.


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[kenhamady]

Shouldn't the adjustment be .49999999 instead of .5? If I have an integer like 5.0 and add .5 to it before rounding then it would round to 6. And if you are rounding any negative numbers you should read this article:

http://kenhamady.com/cru/archives/19

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[dgillz]

Ken,

Yes you are correct.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[lbass]

Try:

-int(-{table.field})

-LB