Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Financial Reporting Studio: Get value from a text cell and use it in if

vermioOct 5 2017 — edited Oct 11 2017

Hi,

I actually want to use an if statement that will do something according the Scenario in POV.

It didn't seem easy to me so I put the value of Scenario in a text cell.

Now, I have in Cell[1,A] the value "Forecast" or "Budget".

I tried two different variations:

a) IfThen([1,A]="Forecast",1,2) [with simple or double quotes --> Error] It seems that it can compare numbers only

b) IfThen(GetCell("grid8",1,A,current)="Forecast"1,1,2) --> Error (Unrecognized character Getcell)

Any help would be highly appreciated

Nikos

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2017

Added on Oct 5 2017

#business-intelligence-applications, #business-intelligence-foundation, #hyperion-query-and-reporting

3 comments

683 views