displaying only millions value

[FrequentUser]

I have several values (numeric) in the millions, that I rounded to the millions.

However I want to display only

$20 for $20,000,000
$14 for $14,000,000 etc.

It's probably an easy solution, but I need it quick.

Crystal Reports XI, MSSQL 2000, ODBC

 

[satinsilhouette]

I don't know of a way to do that with the format function on the field, you could do it in charts, but not on fields. I believe you would have to write a formula to transform the field into what you want.

Thanks so much!
satinsilhouette

 

[Madawc]

divide by a million, and round or truncate the result, depending on the output you want.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10