You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!