>I have the need to display currency left justified and trimmed of blank spaces with two decimals and thousands seperator.
>
>If I use the format @B$ by selecting the Currency and the Left Justify option I get the following:
>$123456.1234
>
>If I change it to $999,999.99 I get the following
>$ 456.66
>$123,123.55
>
>I need
>
>$1.55
>$123.45
>$123,345.99
>
>What am I missing?
Try
* Before runniung report
SET DECIMALS TO 2
*For output:
? TRANSFORM(yCurrencyvalue)
>
>TIA