OraFAQ Forum: Business Intelligence » Need help for number format

Home » Fusion Middleware & Colab Suite » Business Intelligence » Need help for number format (XML publisher)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need help for number format [message #379072]

Sun, 04 January 2009 07:52

shadab.biotech
Messages: 2
Registered: January 2009

Junior Member

Hi,
I need to modify the comma separated number format to decimal separated format of number in XML Publisher
ie 10,000.00 should be displayed as 10.000,00
I need to apply this transistion on a field that is calculating the sum of amount.

Thanks,
Shadab.

Report message to a moderator

Re: Need help for number format [message #435485 is a reply to message #379072]

Wed, 16 December 2009 07:45

tukyunaaya
Messages: 5
Registered: December 2009
Location: India

Junior Member

i dont think this is possible. coz i tried may combinations but the report failed to generate in all the cases.

[Updated on: Wed, 16 December 2009 07:51]

Report message to a moderator

Re: Need help for number format [message #435548 is a reply to message #435485]

Wed, 16 December 2009 12:14

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Change the rtf code from "##,##0.00" to "99G990D00".
# -> 9 -- any number
, -> G -- Thousand Separator
. -> D -- Decimal Separator

By
Vamsi

Report message to a moderator

Previous Topic:	Amount coming as Date Format
Next Topic:	report and Page header should be different ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 14:56:08 CDT 2024