OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Oracle Financial Analyzer Link to Excel

Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Financial Analyzer Link to Excel (2002)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Financial Analyzer Link to Excel [message #645081]

Wed, 25 November 2015 20:08

Excel-Access
Messages: 3
Registered: November 2015

Junior Member

Not sure if you can provide your expert opinion on a similar change - please see below

In cell E9 I have X0671

Current the formula in G9 is =xpDimDESC("REPCOL",E9,1)

and this produces Period Quarter 3 Forecast

I would really like a way to instead call this Period Budget

I tried the following and it failed miserably giving me #VALUE!

=TEXT(--xpDimDESC("REPCOL",E9,1), "Period Budget")

I welcome any suggestion to modifying the formula

Report message to a moderator

Re: Oracle Financial Analyzer Link to Excel [message #645082 is a reply to message #645081]

Wed, 25 November 2015 23:42

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Hi,

Welcome to the forum!

Please read and follow the OraFAQ Forum Guide and How to use [code] tags.

Is your question related to SQL or PL/SQL? It seems you are asking Microsoft Excel related question.

Report message to a moderator