You need to sign in to do that
Don't have an account?
SFDCAdmin73
Report Formula on Opportunity with Products report?
Hi Guys,
I am not sure if this possible but I am going to ask any way. I have an opportunity with product report. The report is filtered to display opportunities for a specific opportunity record type and opportunities with Stage = 'Closed Won'.
On this report, I created a Win Ratio report formula. See formula below. In the report formula I am dividing by the total # of opportunities (Account.Total_Opps__c:SUM). However I need to divid by the total # of opportunities by OEM and not Account. OEM is picklist field that appears on the opportunity record. Is it possible for figure out the Total # of Opportunities by OEM for the current quarter regardless of Opportunity status?
IF(WON:SUM=0,0,WON:SUM/Account.Total_Opps__c:SUM)
I appreciate the help!
I am not sure if this possible but I am going to ask any way. I have an opportunity with product report. The report is filtered to display opportunities for a specific opportunity record type and opportunities with Stage = 'Closed Won'.
On this report, I created a Win Ratio report formula. See formula below. In the report formula I am dividing by the total # of opportunities (Account.Total_Opps__c:SUM). However I need to divid by the total # of opportunities by OEM and not Account. OEM is picklist field that appears on the opportunity record. Is it possible for figure out the Total # of Opportunities by OEM for the current quarter regardless of Opportunity status?
IF(WON:SUM=0,0,WON:SUM/Account.Total_Opps__c:SUM)
I appreciate the help!