Skip to Main Content
Forums

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!

Counting or summing everything before today's date

ZFMA86Mar 11 2013 — edited Mar 13 2013
Gurus,

Using the Answers tool in the column formula box, I want to count (or SUM) everything that has a date less than today's date. I have a column labeled "Suspense Date" which has dates in this format: 02/28/2013.

There are thousands of records with a "Suspense Date" less than that date. What would be a good expression to use to count these? It will also need to update each day when I run the report. I was thinking something like:

SUM(CASE WHEN "Pending Claim - Suspense"."Suspense Date" <= TODAY'S DATE THEN 1 ELSE 0 END)

I just need to know what I use to indicate "Today's Date"?



Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2013
Added on Mar 11 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
6 comments
628 views