How to count sub Master-Detail Body

[_henry_]

Dear all,

I am having an issue about how to count a sub-summary header but yet I forgot how to do it.

I attached a small example file. Please take a look at the "Print Layout" layout.

In there, I would like to see total customer. Manually, it would be counted as 3 customers, but how to do it in calculation?

Thank you for help and suggestion.

As usual, if this has been discussed before, please let me know the link and I can read and learn it.

Thank you.

Test.zip

[comment]

See:

http://fmforums.com/forum/topic/61158-number-of-employees-from-payroll-report/page__p__289204#entry289204

[_henry_]

Hi Comment (Michael),

Thank you for your information. Is this working for two tables? I've tried several times but it didn't work as expected.

I've tried created 2 new fields on table "ItemPurchased":

cInverseCount (calculation) = 1 / GetSummary (sCount ; ItemName )

sCountCustomers (summary) = Total of cInverseCount

PS: sCount (summary) = count of ItemName

Did I miss something?

I've searched this one reciprocal and read this one http://forums.filemaker.com/posts/4f9909b2d0 but the sample file is on the same table. Can it be done on two table? if yes, how? Any help would be appreciated.

Thank you.

[comment]

Have you read the thread to the end?

[_henry_]

I think I get it thanks.

Well, the problem is I should do on fkCustomer instead of ItemName. That's the issue. But now it's fixed.