Using Export, The Raiser's Edge can perform a calculation on many amount fields and summary amount fields using the field's Format settings. (Note: This is available on many fields but may not be available for all amount fields.)

For example, let's create three asks using a donor's last gift:
  • The first amount is 25% less than the last gift amount.
  • The second amount the last gift amount exactly.
  • The third amount is 25% more than the last gift amount.
To create these asks in an Export:
  1. Create or open an existing constituent Export, such as a mailing list Export.
  2. On the Output tab, select Last Gift > Gift Amount
  3. Enter the desired settings for the Last Gift.
  4. Click OK.
  5. Add a second Last Gift Amount by double-clicking on Last Gift > Gift Amount.
  6. Add a third Last Gift Amount by double-clicking on Last Gift > Gift Amount.
  7. On the first Last Gift Amount (added in steps 2 through 4), right click on the selected Last Gift > Gift Amount field. Select Format.
  8. In the new Amount Format window select Decrease, by Percent, and type 25. (Optionally, mark Round to whole numbers.)
    25% decrease ask
  9. Click OK.
  10. On the second Last Gift Amount (added in step 5), right click on the selected Last Gift > Gift Amount field. Select Format.
  11. In the new Amount Format window, leave the setting on Neither. For our example, this field is the actual Last Gift Amount, so click OK to close. 
    Same as last gift ask
  12. On the third Last Gift Amount (added in step 6), right click on the selected Last Gift > Gift Amount field. Select Format.
  13. In the new Amount Format window select Increase, by Percent, and type 25. (Optionally, mark Round to whole numbers.)
    25% increase ask
  14. Click OK.
  15. Optionally, edit the Column Heading so it's clear which Last Gift Amount field is which as shown in the examples above:
  • Right click on the first Last Gift Amount field > select Column Heading... Enter Last Gift minus 25% and click OK.
  • Right click on the second Last Gift Amount field > select Column Heading... Enter Last Gift and click OK.
  • Right click on the third Last Gift Amount field > select Column Heading... Enter Last Gift plus 25% and click OK