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!

SUM CALCULATION NOT PICKING UP NEGATIVE VALUES

444724Oct 10 2005 — edited Oct 12 2005

Hi...
I am trying to do a very simple calculation SUM(quantity invoiced * unit price). This works fine where the unit price value is positive(+) but if it is a negative(-) then it just displays a blank (null value).
I have tried SUM((quantity invoiced * unit price)+0) and SUM((nvl(quantity invoiced,0)) * (nvl(unit price,0))) but this does not work.
Is there any way to display both positive and negative sums?
I am using version 4.1 disco
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 9 2005

Added on Oct 10 2005

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

3 comments

966 views