>Interesting, because the One Time Pymt in my ebase ver 1.02 has the same >problem. And I haven't tinkered with it either--just looked. I get only >monthly or quarterly amounts showing. I thought I had done all the upgrades >to get to 1.03 as posted long ago and far away. > >This is what the current Amount/Regular field definition says:
Note that there is no reference to "One Time Pmt" in the definition below. >Round( >Case( > >not IsEmpty(Amount\Irregular), Amount\Irregular, > >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) > >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) -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ------------------ 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 ---------------------------------------------------------------------
