Skip to content

Instantly share code, notes, and snippets.

@cdcarter

cdcarter/Donor Analysis Formula

Created February 19, 2016 16:41
Show Gist options
  • Save cdcarter/6b49a3caaa63ba699f64 to your computer and use it in GitHub Desktop.
Save cdcarter/6b49a3caaa63ba699f64 to your computer and use it in GitHub Desktop.
Download ZIP
donor analysis formula
Raw
Donor Analysis Formula
IF( npo02__TotalOppAmount__c = 0, "Non-Donor",
IF( npo02__OppAmountThisYear__c > 0 && npo02__OppAmountThisYear__c = npo02__TotalOppAmount__c, "New",
IF( npo02__OppAmountThisYear__c > npo02__OppAmountLastYear__c && npo02__OppAmountLastYear__c != 0, "Increased",
IF( npo02__OppAmountThisYear__c < npo02__OppAmountLastYear__c && npo02__OppAmountThisYear__c != 0, "Decreased",
IF( (npo02__OppAmountLastYear__c != 0 || (npo02__OppAmountLastYear__c = 0 && npo02__TotalOppAmount__c != 0)) && npo02__OppAmountThisYear__c = 0, "Lapsed",
IF( npo02__OppAmountThisYear__c = npo02__OppAmountLastYear__c && npo02__OppAmountLastYear__c != 0, "Renewed",
IF( npo02__OppAmountThisYear__c > 0 && npo02__OppAmountLastYear__c = 0 && npo02__TotalOppAmount__c > 0 && (npo02__TotalOppAmount__c != npo02__OppAmountThisYear__c), "Recovered","Error"
)
)
)
)
)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment