What kind of field is YTD?
Is the layout you used in performing the find based on the table in which YTD is defined?
The more you can tell us about the structure of your table and design of the layout from which you performed the find, the better.
YTD is "YTD donations received" and it is the sum of two other fields. The layout I use to perform the find is based on the table in which YTD is defined, but the data eventually comes from a nother table called "Donations".
I changed the YTD from
If(YTD Pledge>0; If(YTD Pledge>YTD PP; Donations::YTD Payments+YTD Pledge; YTD PP);Donations:: YTD Payments)
YTD=If(YTD Pledge>0; If(YTD Pledge>YTD PP; YTD Payments+YTD Pledge; YTD PP); YTD Payments)
YTD Payments=Donations::YTD Payments in the table/layout I am using for the find and now it works.
Is the lesson here that I shoud always execute a find on a layout based on the table the variable is defined?
No, but I'm looking for whether your issue does or does not match a report in my Known Bugs Database. I've found one that may match but don't know enough about your database design to tell for sure:
For More Information see: Finds on calculation fields computing values from global field based relationship fail
This is one of many acknowledged bugs that can be found in the Known Bug List thread here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: http://www.4shared.com/file/8orL8apk/FMP_Bugs.html
unfortunately it is still not working and I do think it is the same problem described in the Known Bugs Database. If I open the database management, choose any field, open that fields definition, click OK and close the database management, the find works until next time I log in.
so, since it is a know bug, they are working on it (since Nov 2010) and there is nothing to do but wait?
I do think it is the same problem described in the Known Bugs Database.
so, since it is a known bug,...
It either is or is not the same issue, but not both. I can't tell enough from here to tell if it is or is not. If it is, the known bugs list is a privately produced and maintained list (by me). It is not an official list nor does it indicate anything about when or if FileMaker Inc. will correct the problem. If it is not, it needs to be reported in the Report an Issue section of the forum (which is supposed to be used to report possible software bugs--see tab at top of this screen) and in due time, if a FileMaker Inc representative confirms that this is a bug, I'll add it to the list.
I think it is the same issue.