Oracle Business Intelligence Applications

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

How to display amounts in Excel Accounting format?

Received Response
81
Views
8
Comments

Hi,

Oracle EBS 12.1.3

Using BI Publisher, how do I display the amounts in Accounting format in Excel?

I am able to display the amounts in the currency format using <?format-number:ITEM_TOTAL;'$9G999D99'?>

However the business wants it be displayed as below (Accounting format in Excel) where zeroes are displayed as dash.

Thanks in advance.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.