Excel Formula Linked to Oracle Database

[Excel-Access]

I am using Oracle Financila Analyzer that is linked to Excel

Currently in Cell I5 I have the following:

X201412

This is translated as 2014 December

Cell I6 has the formula

=xpDimDESC("CTIME",I5,1)

which gives December 2014

Solution was: =TEXT(--xpDimDESC("CTIME",I5,1), "mmm\. yyyy")

My question is:

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

 

[WEBBERR]

I don't really recognise the function which is already in the cell

but you could try the following and see if that does the trick.

=If(xpDimDESC("REPCOL",E9,1)="Period Quarter 3 Forecast","Period Budget",xpDimDESC("REPCOL",E9,1))