CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Eliminating report results where one field has a null value

edited Aug 2, 2011 12:35AM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered
I am reporting using a Quantity field from the Opportunity. This field is a number field, and is not a required field. In some opportunities the field is left blank; I want to eliminate these records where the Quantity field is blank from my report but when I filter on the quantity field using "is not null", or "is not in or is not equal to 0" or "is >0", the report never finishes running. 
The value that defaults to the Quantity field for these records in the report if I do NOT try to filter them out is 0.00.

Suggestions? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center