Skip to content

Oracle Communities

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
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

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

44

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 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