Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Number to word conversion in RTF Template

Received Response
400
Views
4
Comments

Summary

Number to word conversion in RTF Template

Content

Hi,

In a rtf template i am doing a running total, after the running total i want to show that amount in words for this i have used the below statement then it is showing in words, but i have a requirement is like before it need to show as 'Rupees' and after to show as 'only' but it is not coming.  Please advise me how to do this in the rtf level only.

<?xdoxslt: toWordsAmt(xdoxslt:get_variable($_XDOCTX,'RUNTOT'))?>

For example: if running total is 10190.00 then its coming like Ten thousand one hundred and ninety

My requirement is

Rupees Ten Thousand One Hundred and Ninety only

Answers

  • Itsmahesh81
    Itsmahesh81 Rank 3 - Community Apprentice

    Please let me know, is there any other approach to show it, because i am generating a running total in the rtf level and the xml tags are generating basing on Data Template Query based.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Isn't it possible to add it as a static text?

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Cannot you write like

    Rupees <?xdoxslt: toWordsAmt(xdoxslt:get_variable($_XDOCTX,'RUNTOT'))?> only.

    If Rupees are coming dynamically means sometime you need to print Dollar or respective currency then you can generate the tag in XML based on currency code and you can use to your rtf.

  • Alok Chowdhary -91805
    Alok Chowdhary -91805 Rank 1 - Community Starter

    Hi,

    You can simply hardcode the only value at the end it would work.

    Or if you are facing issue with respect to null value then you can write a condition clause and try out that.

    Thanks.