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!

Exclude some columns from calculated item

760960Feb 25 2011 — edited Feb 28 2011

I'm using OBI 11.1.1.3
I need in my report calculated item, but need to exclude from it some columns, specifically percent column.

Report looks like this (PivotTable or Table view)

---------Column1---Column2----Column3
Row1 : double - double - percentage
Row2 : double - double - percentage
Row3 : double - double - percentage
Row4 : Row3/Row1 : double - double - percentage (CALCULATED ITEM)

So, all I'm trying to do is exclude or just leave blank from this calculated item column with datatype PERCENTAGE (Column3), how can I achieve this behaviour?
I just want to get something like this, I dant want to make calculation on COLUMN3

---------Column1---Column2----Column3
Row1 : double - double - percentage
Row2 : double - double - percentage
Row3 : double - double - percentage
Row4 : Row3/Row1 : double - double - NULL/0 (CALCULATED ITEM)

Can anyone help me ?

Edited by: Guram Kashmadze on Feb 25, 2011 10:24 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2011

Added on Feb 25 2011

#answers, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #item, #obiee, #reports

4 comments

258 views