Categories
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
-
@Kevin McDermott-Oracle You on vacation? 😊
0 -
Nope, I just do not normally monitor this forum.
This is not a feature they can use in EBS 12.1.3.
In 12.2 they could use an Excel layout. But they are not supported in 12.1.3.
Rgds,
Kevin
0 -
@Kevin McDermott-Oracle Apologies for calling you out :-) You have always answered my BI/XML Publisher questions. Hence! :-)
Thanks for responding. Did I post this question in the wrong forum? This is the BI/XML Publisher forum, right?
0 -
NP.
This is Analytics, we still have BIP (OAS) under
Kevin
0 -
Bummer! No wonder you didn't respond :-) Sorry for posting in the wrong forum :-(
0 -
BTW can you move this question to that forum?
0 -
I would say they can't move the question because it's a different node in the forum platform ("tech" vs "mosc").
This forum isn't technically wrong for a BIP question (ok, the category for OBIEE/OAS would have been a better match), but it's the public one while the MOSC forum require a valid support contract attached to your profile to access it (and there you often find the same categories as in here, or more detailed choice like BIP having a category).
0 -
Have a good day!
Kevin
0
