How to Return Only "# of Leads Converted" Within the Current Week?
Last updated on AUGUST 31, 2016
Applies to:Oracle Fusion Sales Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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?
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms