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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IFThen Function - Text Result Problem

ankistJul 15 2010 — edited Jul 19 2010

Helllo,

There is a problem as text results of IFThen function seems "Zero" value.

I wrote a IFThen function as below

IfThen([CJ]=1,[CN],IfThen([CJ]=2,[CO],IfThen([CJ]=3,[CP],IfThen([CJ]=4,[CQ],IfThen([CJ]=5,[CR],IfThen([CJ]=6,[CS],IfThen([CJ]=7,[CT],Ifthen([CJ]=8,[CU],IfThen([CJ]=9,[CV],IfThen([CJ]=10,[CW],[CX]))))))))))

and all results are in a cell as text.

but with same rule I run with numeric value, the results are calculated rightly.

How can I run IFThen funciton with text result?

thnks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2010

Added on Jul 15 2010

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

4 comments

1,662 views