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!

ROW COUNT ISSUE WHEN USING CASE STATEMENT IN A COLUMN

3601907Oct 8 2019 — edited Oct 12 2019

Hi,

I have a report which has a case statement in one of the columns. When I use a formula to get row count I am getting an incorrect row count. When I remove this column the report renders showing the correct count. I am using MAX(RCOUNT(1)) and also tried MAX(COUNT(DISTINCT(RCOUNT(1)))). Both of these give the same result. Any ideas anybody? I am on 12c Platform.

Added on Oct 8 2019

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

2 comments

249 views