>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...
I just checked, and it's not. Good eye, I didn't think to check for that specific bug. > >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 >--------------------------------------------------------------------- -- -- 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 ---------------------------------------------------------------------
