Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ROW COUNT ISSUE WHEN USING CASE STATEMENT IN A COLUMN

Received Response
81
Views
2
Comments
3601907
3601907 Rank 5 - Community Champion
edited Aug 13, 2024 5:23PM in Oracle Analytics Forum

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.

Answers

  • SonPat99
    SonPat99 Rank 6 - Analytics & AI Lead

    What are you trying to achieve (COUNT)?

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

    Both are very different. Please check

  • Robert Angel
    Robert Angel Rank 8 - Analytics & AI Strategist

    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.