Forum Stats

  • 3,851,377 Users
  • 2,263,968 Discussions
  • 7,904,690 Comments

Discussions

Cell Sum in Oracle BI Discoverer

4abdbe28-3b62-4e34-9797-0a69a239b1ca
edited Jan 18, 2016 4:45PM in Discoverer

Hello, I hope this is right place to ask question about Oracle BI Discoverer 11g (11.1.1.7.0)

I’m trying to do a Cell Sum on a Calculation. The column which uses calculation calls function: MyFunction(myID). The function always returns a number, never NULL.

When I’m trying to do a Cell Sum for this column it is not working. What I really mean: if I pass hardcoded value into my function the Cell Sum works just fine. If I pass ID (value from the different column like MyFunction(myID) ) the Cell Sum stops working even though I can see values in that column. I'm new to Oracle BI Discoverer and I was wondering if I’m doing something wrong or there is a limitation.

Thank you, Michael.

This discussion has been closed.