Poverty-assessment Tools in TaroWorks come with 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.

The * 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 score total. The result is that when a completed job with a Poverty-assessment Tool form is synced, the scores would be automatically calculated in the salesforce record.

The example formula below assume you will map the 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.