Toggle navigation
my blackbaud
all sites
sphere login
blackbaud labs
noza
test
blackbaud tv
netwits thinktank
usa
uk
pacific
netherlands
canada
nonprofit solutions
resources
support
training
events
partners
company
my blackbaud
all sites
sphere login
blackbaud labs
noza
blackbaud tv
netwits thinktank
usa
uk
pacific
netherlands
canada
How to create a formula to use one amount field for a certain gift type and another amount field for other gift types in Crystal Reports
Search Knowledgebase
Sometimes we need to use one amount field for a certain gift type and another amount field for all other gift types.
For example: if Gift Type is Planned Gift then use Net Present Value, otherwise use Gift Amount
For example (for proposals): if Proposal Status = Funded then use Amount Funded, otherwise use Amount Asked
Article Number:
96266
Products:
Crystal_Reports
Create a formula similar to the one below:
if Gift Type = "Planned Gift" then Net Present Value else Gift Amount
Was this article helpful?