Yess! One small step for data-kind! It works. Thanks Dave :-) Beth > >> Is it different from what it should be? > > Yes, here's what appears in my copy. The second option in the Case > statement sets the regular payment to the amount pledges if the > Payment Frequency is equal to "One Time Pmt". > > Round( > Case( > > not IsEmpty(Amount\Irregular), Amount\Irregular, > > IsEmpty(Amount\Irregular) and Payment Frequency = "One Time Pmt", > Amount Pledged, > > IsEmpty(Amount\Irregular) and Payment Frequency = "Quarterly", > > Amount Pledged/ (If(PatternCount(Duration,"M"), > TextToNum(LeftWords(Duration,1))/3, TextToNum(LeftWords(Duration,1)) > * 4)), > > Amount Pledged/ (If(PatternCount(Duration,"M"), > TextToNum(LeftWords(Duration,1)), TextToNum(LeftWords(Duration,1)) * > 12)) > ),2)
------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
