Forum Stats

  • 3,752,060 Users
  • 2,250,453 Discussions
  • 7,867,705 Comments

Discussions

How to display amounts in Excel Accounting format?

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.

Answers