formatting currency zeroes

[princessinthetower]

Is there a way to format cents in currency so that

$250.41 appears as $250.41
but
$250.00 appears as $250

This will be used in a narrative not a financial report so it's just a matter of appearance.

 

[Naith]

Infobabe,

Format your field. Select Custom Style in the Number tab, and press Customise - or Customize as the Americans insist on spelling it.

Decimal and Rounding should already be set to two decimal places.

Hit Decimal's x2 button, and slip this in:

numbervar zerofix := remainder(CurrentFieldValue,int(CurrentFieldValue)) ;
if zerofix = 0 then 0
else if remainder(zerofix*100,100) = 0 then 1
else 2

Naith

 

[princessinthetower]

Thanks. I knew it was in there somewhere!