Hi,
��� I am having a problem in my database with the YTD and Last Yr totals showing as zero when they should not be so.� I have run the Replace All Find Fields which had no effect.� I also went into the SUM YTD define field and unchecked the box "Do not evaluate if all referenced fields are empty".
��� Is there something else I can try?
You don't say which version of ebase you are using, but if it's
earlier than 1.03, there is a known bug in the Fiscal Year calculation
used to update summary fields like YTD $. I have included below the
correction from the help page on the ebase site.
----------
1) SUM::Current Fiscal Year Bug
----------------------------------
Fixed a bug in a field calculation that was causing users to get one
result when running "Replace All Find Fields", yet getting different
results when running "Replace Current Find Fields".
TO ADD THIS FIX TO YOUR VERSION OF EBASE:
--------------------------------------------
A) Determine if you have this problem:
-Get into ebase using your master password. Once you're on the HOME
screen, select: File->Define->Fields.
-Double-click on the field named "SUM::Current Fiscal Year".
-The "Specify Calculation" dialog box will appear. The correct calculation
for this field is as follows:
If(Month(gToday)>=setup::Fiscal Year Number and setup::Fiscal Year Number>
1, Year(gToday) + 1, Year(gToday))
B) If the calculation for your field reads differently, you should correct
it by:
-Copying this calculation:
If(Month(gToday)>=setup::Fiscal Year Number and setup::Fiscal Year Number>
1, Year(gToday) + 1,
Year(gToday))
-Paste this calculation into the "Specify Calculation" dialog box.
-Click the "OK" button.
-Click the "Done" button.
-You should then select and run the "Replace All Find Fields" script from
the Scripts menu, leaving the date blank so that it runs for your entire file.
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------ --
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
---------------------------------------------------------------------
