varying decimel point

[djabra31498]

How do I get it to display 10.2 when the value is 10.2, but display 10 when the value is 10

 

[synapsevampire]

This is Crystal version dependent:

Right click the field and select format field->Number tab->Customize->X 2 next to Decimals and use:

if val(right(totext({Orders.Order Amount},2,""),2)) = 0
then
0
else
if val(right(totext({Orders.Order Amount},2,""),1)) = 0
then
1
else
2

There's probably a more elegant means, but this will work.

-k

 

[djabra31498]

FABULOUS! Worked perfectly. thx