Currency formatting on CR-9 problem

[Molkas]

How can I format a field to show currency value this way:
$1 (instead of 1,250)
$125 (instead of 125,078)
$1,125 (instead of 1,125.345)

Thank you. - Molkas

 

[lbass]

I'm assuming your last example contains a typo, and that you really meant: 1,125,345

If you want to show all but the last three digits, then use:

$(truncate({table.number}/1000))

If you want the values rounded, then use:

$(round({table.number}/1000))

-LB

 

[Molkas]

Thank you very much for your assistance LB. The example does contain a typo; the solution to my field is actually the rounded values you provided. My report is working great!. Thank you again.
Molkas

 

[synapsevampire]

You can also right click any field ands select format field->Number tab and select an existing format or select customize and create your own from the interface.

To globally change them so you don't need a formula or format each, select File->Options->Fields->Currency and Crystal will remember that formatting for all currency type fields going forward.

-k