2 Replies Latest reply on Oct 12, 2019 4:58 PM by Robert Angel

ROW COUNT ISSUE WHEN USING CASE STATEMENT IN A COLUMN

3601907 Oct 8, 2019 7:01 PM

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.

1. Re: ROW COUNT ISSUE WHEN USING CASE STATEMENT IN A COLUMN

SonPat99 Oct 12, 2019 10:58 AM (in response to 3601907)

What are you trying to achieve (COUNT)?
Are you taking simple counts or Running Counts (RCOUNT)?

Both are very different. Please check
Like Show 0 Likes(0)

Actions
2. Re: ROW COUNT ISSUE WHEN USING CASE STATEMENT IN A COLUMN

Robert Angel Oct 12, 2019 4:58 PM (in response to 3601907)

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.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.