decimal in Crystal XI

[karnd]

Hi ,
For an amount field i should not have to ROUND it at all but need to truncate the decimal after the digit.

Eg:1000.20 should have to show as 1000
1000.75 should have to show as 1000

Thanks a lot,

 

[bdreed35]

Create a formula and pass the field to the truncate function:

Truncate({table.field})

~Brian

 

[karnd]

Hi,

But it does not truncate the digits after the decimals.

I tried truncate(field,0)
truncate(field,-1)
truncate(field,1)

and etc..

thanks

 

[lbass]

If after using the following on a field = 1000.75:

truncate({table.field})

...you are seeing 1000.00, all you need to do is select the field and click on the decrease-decimals icon to remove the decimals in the display.

-LB

 

[karnd]

Hi,

Great!this helps but is it a new feature available from CRXI or before also?

Thanks
regards,

 

[lbass]

Truncate() has been available since 8.0 and possibly earlier.

-LB

 

[karnd]

thanks a lot for your kind info.

regards,