My Oracle Support Banner

Total Weighted Quantity Counting Excluded Models (Doc ID 2745099.1)

Last updated on FEBRUARY 01, 2021

Applies to:

Oracle CRM On Demand - Version 031CS to 031CS [Release 31]
Information in this document applies to any platform.

Goal

In the report we excluded the count of some ‘models’. Like this in the Quantity field.

case when "Product"."Product Name"= 'Project' OR "Product"."Product Name"= 'System Support' OR "Product"."Product Name"= 'Peripherals' OR "Product"."Product Name"= 'Software' OR "Product"."Product Name"= 'Change Request' then 0 else "- Quantity"."Total Quantity" end

We also have the field Total Weighted Quantity and here we added a formula to display the Total weighted quantity like this:
"- Quantity"."Total Quantity" * CAST((Case when Opportunity.PICK_10 = '10%' then '10' when Opportunity.PICK_10 = '20%' then '20' when Opportunity.PICK_10 = '30%' then '30' when Opportunity.PICK_10 = '40%' then '40' when Opportunity.PICK_10 = '50%' then '50' when Opportunity.PICK_10 = '60%' then '60' when Opportunity.PICK_10 = '70%' then '70' when Opportunity.PICK_10 = '80%' then '80' when Opportunity.PICK_10 = '90%' then '90' when Opportunity.PICK_10 = '100%' then '100' ELSE '0' END) as INTEGER)/100

The problem is now, when the excluded model is displayed like 0 in the background it’s still a 1.
The 1 is used in the Total Weighted Quantity.
How can I adjust the Formula so the system will use 0 for the excluded models so the Total Weighted Quantity is displayed correctly?

 


 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.