Skip to Main Content

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.

Comments

SonPat99

What are you trying to achieve (COUNT)?

Are you taking simple counts or Running Counts (RCOUNT)?

Both are very different. Please check

user11440683

Your issue is probably one of the order of aggregation, due to whether your objects are physical or logical, on the case of case statements and aggregation you nearly always need it to be based on physical measures.

My advice would be to create your logic in the rpd if possible, reproduce your case statement based on the physical, then your results will not be spurious.

1 - 2