(Progress out of Poverty Index (PPI) templates from Grameen Foundation include the 10 questions with scoring built in and also a lookup table that translate the scores to the likelihood that one household is below a certain line (eg. National Poverty Line). Currently these scores and percentages can be seen in the table of form responses and the exported CSV file but the poverty likelihood currently cannot be mapped into a field directly.

However as of release 2.19.0 the *PPI raw score* (0-100) can be mapped into object fields. Therefore it is possible get the poverty likelihood by creating an additional formula field (see below) to act as a look-up table, outputting the probability (in percent) based on the mapped PPI total. The result is that when a completed job with a PPI form is synced, the scores would be automatically calculated in the salesforce record.

The example formula below assume you will map the PPI raw score to a field named "PPI Score".

IF( PPI_Score__c < 5 , 0.954, IF( PPI_Score__c < 10 , 0.95, IF( PPI_Score__c < 15 , 0.858, IF( PPI_Score__c < 20 , 0.825, IF( PPI_Score__c < 25 , 0.773, IF( PPI_Score__c < 30 , 0.679, IF( PPI_Score__c < 35 , 0.637, IF( PPI_Score__c < 40 , 0.464, IF( PPI_Score__c < 45 , 0.369, IF( PPI_Score__c < 50 , 0.30, IF( PPI_Score__c < 55 , 0.178, IF( PPI_Score__c < 60 , 0.139, IF( PPI_Score__c < 65 , 0.061, IF( PPI_Score__c < 70 , 0.046, IF( PPI_Score__c < 75 , 0.038, IF( PPI_Score__c < 80 , 0, IF( PPI_Score__c < 85 , 0.004, IF( PPI_Score__c < 90 , 0, IF( PPI_Score__c < 95 , 0,0))))))))))))))))))) |

## Comments

0 comments

Please sign in to leave a comment.