Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Hi Ed,
THanks for putting me on the path to solving this. I see that TRANSFORM does great if the value is a currency value. If it is a numeric value how can I change it to currency in the report?
THanks
>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement