Formula help

[JasonMcConnell]

Hi,


When I add a simple calculation to a formula field in crystal 8.5 and also crystal XI it calculates the wrong result

e.g. 8/9 = 89 instead of 88

I suspect it a rounding problem but I can’t resolve this.

Can anybody help?

 

[CLKCLK]

You can format the formula number field to show more decimal places 0.8888.

 

[JasonMcConnell]

Thanks,

I have tried that but need the answer to 1 decimal place - 88

Any ideas

 

[fisheromacse]

are you able to use TRUNCATE to 'lose' everything after the decimal value you want?

ie: If you have values:
{table.numbervalue1} = 8
and {table.numbervalue2} = 9


you can try:
truncate(({table.numbervalue1}/{table.numbervalue2}),2)

to change the # of decimal places to 1, change the '2' above to a '1'