I'm new to filemaker and have a question on getting a report to come out
correctly....

I want to do the following..

I want to display the current number of open issues (I have that one figured
out - total records - records that are completed) and I want to also show a
count of the change from 7 days ago....

So I want to see basically what has happened in the last 7 days as far as
number of completed projects (what I got done)

Can this be done?

Thanks

On Aug 6, 10:33 am, "Ryan Wunderlich" <rwundr... [at] hotmail.com> wrote:
> I'm new to filemaker and have a question on getting a report to come out
> correctly....
>
> I want to do the following..
>
> I want to display the current number of open issues (I have that one figured
> out - total records - records that are completed) and I want to also show a
> count of the change from 7 days ago....
>
> So I want to see basically what has happened in the last 7 days as far as
> number of completed projects (what I got done)
>
> Can this be done?
>
> Thanks

Assuming you are using a modern version, its fairly straightforward.

You'll need a field with the current date in it. (global is fine); set
the field to be set when the file is opened, and if you are going to
run the the system 24x7 set it update when you move to the layout that
shows this calculation.

Define a another global date field as a calculation set to the field
above "minus 7" to give you the date 7 days ago.

Next, your projects table must have a completed date; define a
relationship, from the dateminus7 field to the project completion date
using a > instead of the normal = relation operator. This will give
you the set of records that have been completed AFTER the dateMinus7.
(You may want >= instead of > depending on your exact requirement.)

Finally define a calculation field to calc
Count(thatRelationship::primarykey) to find out how many records are
in that set.

That will tell you how many records were closed in the last 7 days.

-regards,
Dave