CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Revenue Strike Rate %

edited May 13, 2014 1:58PM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered ✓

I'm having a problem calculating our strike rate on revenue.

I'm using a pivot to summarise the information.  I've used a filter on two revenue metrics column to calculate wins and losses.  My formula for calculating the strike rate would be WINScolumn / (WINScolumn+LOSSEScolumn)*100 as follows:-

FILTER("- Opportunity Custom Metrics".S_INDEXED_CUR_0 USING (Opportunity."Sales Stage" = 'Closed/Won')) / FILTER("- Opportunity Custom Metrics".S_INDEXED_CUR_0 USING (Opportunity."Sales Stage" = 'Closed/Won'))+FILTER("- Opportunity Custom Metrics".S_INDEXED_CUR_0 USING (Opportunity."Sales Stage" = 'Closed/Lost'))*100

In the pivot I either get a blank column or a copy of the Losses column multiplied by 100.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center