Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

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

41

Views

1

Comments

Ram Prakash

Ram Prakash Rank 1 - Community Starter

July 2017 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 Coach

July 2017

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