format_currency [message #219411] |
Wed, 14 February 2007 05:00 |
tomaac
Messages: 10 Registered: May 2006
|
Junior Member |
|
|
I have a Report where one value is formatted as follows:
..
SRW.REFERENCE(:value1);
SRW.USER_EXIT('FND FORMAT_CURRENCY
CODE=":C_BASE_CURRENCY_CODE"
DISPLAY_WIDTH="14"
AMOUNT=":value1"
DISPLAY=":result_value"
MINIMUM_PRECISION=":C_BASE_PRECISION"'
..
return result_value;
note that C_BASE_PRECISION has a value of 2.
So, if I have value1 = '10', then in my report I see 10.00 (this is ok).
However, if I have value1 = '10.1234', then in my report I see 10.1234, but I need 10.12 (I need two digits after decimal point).
Please, help me to find out how to format this using FND FORMAT_CURRENCY (or probably some other way)?
|
|
|