Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud November 2025 Update Unlock faster trends, personalized analytics, and efficient data management with the latest OAC AI and admin enhancements.
Introducing the Oracle Analytics & AI Challenge 2026 Showcase your Analytics & AI skills in this Community Challenge!

Oracle Analytics Cloud and Server

Categories

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

How print check amount in text format

Received Response

42

Views

1

Comments

Ram Prakash

Ram Prakash Rank 1 - Community Starter

Jul 4, 2017 7:00AM in Oracle Analytics Cloud and Server

Summary

How print check amount in text format

Content

Hi,

I have a requirement to print the check amount in text format in BI publisher.

Eg: if the amount 525.00

it should print as FIVE TWO FIVE.

can anyone help me in this.

0

Answers

Sherry George Rank 7 - Analytics & AI Coach

Jul 4, 2017 7:00AM

In rtf template you can use <?xdoxslt: toWordsAmt()?>

eg: <?xdoxslt: toWordsAmt(DATA/Amount)?>

or you can handle it in SQL query if using SQL query as data model.

Check this blog: https://blogs.oracle.com/xmlpublisher/numbers-to-words-update

0