How to Return Only "# of Leads Converted" Within the Current Week? (Doc ID 2178110.1)

Last updated on AUGUST 31, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

Customer is trying to filter a column for # of leads converted within current week.
How to return only the "# of Leads Converted" within the current week?

Customer tested: 
FILTER("Lead Facts"."# of Leads" USING WEEK_OF_YEAR("Lead"."Converted Time") = VALUEOF("CURRENT_WEEK"))

But he is getting messages saying that I cannot compare values having different data types:

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms