Hello fmp community!

This is my first post--have been trying to figure this calculation out. It seems like it should be very simple, but can not find a post that deals with same issue.

I have a field that calculates TOTAL RECORDS in entire db. I need another field now that calculates Total Records since Jan. 1, 2007 (YTD). I have a "Date Initiated" field to pull date from.

Can anyone give me any guidance?

Thanks!

Hi chloeno,

Welcome to the forums.

Create a simple number field (lets call it FiscYear) with calculated result that is Year ( DateofEvent ).

You can then use a global number field to on the parent side to enter in the year that you want. Create a relationship from this global field to FiscYear. Now you can just just use a sum (Child::FiscYear) and it will give you the total. You can also use summary fields.

To do this, you would use Go to related record from the parent side (using the same relationship that you created as above) and once the child records are displayed, the summary field will give the result as well.

Now you can just just use a sum (Child::FiscYear) and it will give you the total.

... a count (Child::FiscYear) B)

Hi John, thanks for the reply.

Sorry but I didn't get past the first step. (Would you mind giving me more detail? I'm very novice here!)

ok. I created a simple number field, FiscYear, with calculated results being Year ( DateInitiated ). Is that correct so far?

Then?

Indeed Daniele. I have no idea why I type Sum() Thanks for cleaning up my mess. B)

Chloeno,

Maybe this thread can help