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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Count line items where date isnull and where dates are not null

3025352Nov 13 2015 — edited Nov 13 2015

Hi all,

I have the following 2 requirements that I can't seem to get to work. I need to find out what quotes have been delivered and what quotes haven't. I want to find out if the 'Date Sent' column is null, which decides if the quote has been delivered, and IFNULL I want to count the quotes and aggregate them by the business unit column. For the second requirement, if 'Date Sent' is not null then count them by business unit column.

I'm currently trying to use this function for when the date is null but it's not working correctly for me... COUNT(IFNULL("Agreement Sent Date"."Date", 0))

Thank you for your time and help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2015

Added on Nov 13 2015

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #date

1 comment

988 views