Dears, I need help to create a report that shows a ranking (KPI) that's follow the next statement (formula):
(#.OpportunityOwner / #.TotalOpportunity)*75% +
(#.OpportunityOwnerWon / #.OpportunityOwner)*25%
I waiting for a report that shows the Opportunity Owner KPI, based on Closed Date and Create Date (when the opp its closed won).
1 respuesta
Try something like that:
(OWNER_ACTIVE:SUM / RowCount) * 0.75 + (WON:SUM / OWNER_ACTIVE:SUM) * 0.25
PS: To use formula on your report, you need to group it for something.
