My copy of version 1.02 also has the incorrect calculation for Amount\Regular. Since I'm the only one who uses this database and I KNOW I never touched the Pledges file, it appears to be a bug in Version 1.02 that was fixed in 1.03. Oddly, I don't recall this bug being in the list of fixes...
Thanks for the right calculation, Dave. Carl Dave Shaw wrote: > > >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 > --------------------------------------------------------------------- -- Carl Paulsen New Hampshire Rivers Council 54 Portsmouth Street Concord, NH 03301 603-228-6472 603-228-0423 Fax [EMAIL PROTECTED] ------------------ 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 ---------------------------------------------------------------------
