Hi All, Is there anyway we can change the currency format?
Example Indian Rupees would be displayed as 1,23,456.78
US $ would be 123,456.78
Canada $ would be 123 456,78
Webfocus 8002M, 8009 OS: Windows7
August 04, 2008, 06:38 AM
Danny-SRL
Suresh,
As far as I know, WF provides only CDN (continental decimal notation) where the decimal point is a comma and the separator is a period. If you want something more, use the FTOA function to create an alpha field and then EDIT.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 05, 2008, 11:53 AM
Leah
quote:
US $ would be 123,456.78
Canada $ would be 123 456,78
As Daniel says, there is the CDN, is there any reason you don't want a comma in the Canadian, or was that an error on your post?
Leah
August 06, 2008, 04:09 AM
Danny-SRL
Leah,
I don't think it is an error: there a many countries where the 1000-separator is a space. And in switzerland it is the apostrophe '. Even in calculators!!!
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
August 07, 2008, 02:16 PM
GCohen
Did you try to define your data in the MFD as a curreny, and the name of the currency. e.g. FIELDNAME=PRICE,ALIAS=PR, FORMAT=D9.2,CURR=country_name-from_list ,$
Search the documentation for how to find the list of currencies.(search is in upper right hand of this page)
Release 7.6.9 Windows HTML
August 09, 2008, 10:58 AM
Mikel
Punctuating Numbers with CDN (WF761):
SET CDN = OFF - 123,456.78
SET CDN = ON - 123,456,78
SET CDN = SPACE - 123 456,78
SET CDN = QUOTE - 123'456,78
SET CDN = QUOTEP - 123'456.78
you can then call it via a DEFINE or COMPUTE at any time.
for example
TABLE FILE CAR PRINT COMPUTE TVALUE/D20.2=SALES * DEALER_COST + 0.99; COMPUTE INDIAVAL/A27= INDIAVAL(TVALUE); AS 'Value,in,Rupees' BY COUNTRY IF SALES NE 0 ON TABLE SET STYLE * TYPE=DATA, COLUMN=INDIAVAL, JUSTIFY=RIGHT,$ END
August 11, 2008, 05:48 AM
SureshKumar
Thanks a lot for the info Mikel. was a great piece of info for CDN attributes.
I had a doubt if i could just specify country name or something as a parameter to get the currency values in that format.