Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00936: Missing Expression when using a claculation as a condition item

588244Jul 16 2007 — edited Oct 18 2007

Hi

I created a calculation below to create a subtotal on each row of a group of selected items.

SUM(Invoice Amount)OVER(PARTITION BY Supplier Num ORDER BY Payment Currency Code)

This worked fine - but then I wanted to create a condition based on this calculation and when I used the calculation as a condition item and reran the report I received the 'ORA-00936: Missing Expression' error. So not too sure why it is fine as a calculation but not as part of a condition.

We use Discoverer version 4.1

Am I missing something or is this a bug?

Any help would be very appreciated

Thanks
Marcus

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2007

Added on Jul 16 2007

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

7 comments

3,938 views