AnsweredAssumed Answered

How to calculate repeating values in a related date field?

Question asked by MartonNagy on Jan 17, 2015
Latest reply on Jan 18, 2015 by MartonNagy

Title

How to calculate repeating values in a related date field?

Post

Hi,

I am pretty new to filemaker and I am struggling with an easy problem. I have a parent table containing participants and I have a child table with all their experimental appointments. For a given participant there can be several experimental appointments with date fields (an other infos).  I would like to have a calculation on the layout of my participant infos which would show how many NOT REPEATING dates they have (sometimes one participant has many experimental appointments on the same date and I want to see how many different occasions were they visiting our lab.).

I could easily calculate a sum for all the related date fields, but I can't figure out how to eliminate the repeating dates.

 

Thanks for all the help in advance!

Outcomes