I'm trying to calculate an overall score with a range of 0-100 based on four data points and their percent to completion
Data point 1 25% complete
Data point 2 35% complete
Data point 3 65% complete
Data point 4 80% complete
My attempt was:
If( Datapoint 1 > 24, 25, 0 )+If( Datapoint 1 > 49, 50, 0 )+If( Datapoint 1 > 74, 75, 0 )+If( Datapoint 1 > 99, 100, 0 )
etc....
답변 2개
We are on enterprise, here is the formula:
If( Wk_Sales_BRC_to_Goal__c > 24, 25, 0 )+If( Wk_Sales_BRC_to_Goal__c > 49, 50, 0 )+If( Wk_Sales_BRC_to_Goal__c > 74, 75, 0 )+If( Wk_Sales_BRC_to_Goal__c > 99, 100, 0 )+If( Wk_Wins_to_Goal__c > 24, 25, 0 )+If( Wk_Wins_to_Goal__c > 49, 50, 0 )+If( Wk_Wins_to_Goal__c > 74, 75, 0 )+If( Wk_Wins_to_Goal__c > 99, 100, 0 )+If( WkCold_Call_to_Goal__c > 24, 25, 0 )+If( WkCold_Call_to_Goal__c > 49, 50, 0 )+If( WkCold_Call_to_Goal__c > 74, 75, 0 )
+If( WkCold_Call_to_Goal__c > 99, 100, 0 )+If( Wk_Proposals_to_Goal__c > 24, 25, 0 )+If( Wk_Proposals_to_Goal__c > 49, 50, 0 )+If( Wk_Proposals_to_Goal__c> 74, 75, 0 )+If( Wk_Proposals_to_Goal__c > 99, 100, 0 )
I should mention ..I'm no formula wizard so I could certainly be approaching this the wrong way =)
