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

      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.