You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Number to name conversion of currency value in RTF template

edited Mar 18, 2025 11:05AM in BI Publisher Learning Center

I have currently developed a BIP report using RTF template for a receipt voucher. It contains values in both Arabic and English. I would like to know whether there is a possibility to convert number (currency value) to name in this format : SAR 241.83 → Two hundred forty-one riyals and eighty-three halalas.

Currently I am using the formula "<?xdofx:to_check_number(AMOUNTWITHVAT, 'SAR', 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS') ?>", where AMOUNTWITHVAT is my desired amount field. This formula returns the value as "Two hundred forty one and eighty three"

Additionally, it will be helpful if I could get a possibility of adding the Arabic translation of the number name in the same RTF template itself.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!