Revenue Strike Rate %
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.