Help!!!

I have a data dase in FMP 8.0 and am trying to sum records as I go
along.

Example:
MTD YTD
Jul 2 2
Aug 4 6
Sep 7 13

So YTD for Aug (6)=July YTD (2) +Aug MTD (4)

So I have set up a serial number and Serial-1 number. So I have a
relationship based on Serial number=Serial-1 number.

If I make the YTD field a number I can do replace field contents and
have it be MTD+ Relationship:: YTD and get the corrct number but the
same in a calculation field all I get is?

How do I fix it?

Thanks,

In article <1181839212.518560.23950 (AT) o11g2000prd (DOT) googlegroups.com>,
LADSE <costsheets (AT) ladse (DOT) org> wrote:

I can't see any problem off the top of my head and anything that works
in the Replace window should also work as a Calculation.

The "?" symbol often means that the field simply isn't wide enough to
display the result. Try making the field wider and see if you get real
data. It may also indicate a relationship problem causing a never
ending circle, but usually FileMaker will warn you of these when trying
to leave the Calcaultion window.

There could be a problem when there is no realted data (ie. for the
very first record), so you could use a Calculation that checks this and
only uses the MTD amount when there is no previous month.
eg.
MTD + If (IsEmpty(Relationship::YTD), 0, Relationship::YTD)




Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)