Amount to words conversion in BI Publisher
In Siebel BI Publisher reports, we are trying to convert and translate number to local language words.
Can numbers which are converted into words, also be translated from English into another language e.g. Vietnamese.
Convertion to words is done by the use of:
<?xdoxslt:toCheckNumber($_XDOLOCALE,FieldName,'USD','CASE_UPPER','DECIMAL_STYLE_WORDS')?>
This gives number in words(e.g. Amount=1,234.00, it has to be converted into words which will be “One thousand two hundred and thirty four”). We also need this to be translated to local language.
Any suggestions?