How to sum supressed rows
Hello, I am working with a report in Oracle EPM Planning. In my report, in the first row, I retrieve the value of all bottom members of Account dimension. Then I want to sum only five first positions in this row. I tried using the Sum[1(1:5)] function. It worked the first time, but when I suppress the null values, the sum is no longer correct. I realise that 2/5 positions of the first row contain some zeros and then with suppressing these positions are skipped and the system goes to the next 2 positions which have non zero values. How
Tagged:
0