oracle-databaseoracle12crtfbi-publisher

Convert the total amount in words


I'm converting my total amount into words using bi publisher. Btw, the amount is base on the data from the data set. Can someone help me what to do? Thanks

<?xdofx:to_check_number,sum(COLUMN_NAME, ‘EUR’, ‘CASE_UPPER’, ‘DECIMAL_STYLE_WORDS’)?>

I expect the output to be in words but the actual ouput is blank.


Solution

  • Use the function xdoxslt:toCheckNumber

    Like this:

    <?xdoxslt:toCheckNumber($_XDOLOCALE, sum(COLUMN_NAME), ‘EUR’, ‘CASE_UPPER’, ‘DECIMAL_STYLE_WORDS’)?>
    

    For a detailed explanation, check this page. But bear in mind, this is an undocumented function.