# report dilemna

This topic is 8454 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I need help with my report. The report is structured as follows:

Header: Normal information date, title of report, etc..

Subsummary by c-first of month (Leading): I have this set to break by month. This part contains 1 field

(c-first of month) calculation ="Date(Month(Run End Date), 1, Year(Run End Date))"

Subsummary by substrate number(Trailing): I have it set up to break on product numbers. In this part has 7 fields.

(Substrate number) text field

(Cat Num) calculation= Case(IsEmpty(Substrate Part Number)," ",

Substrate Part Number = 123456789,"AB123",

Substrate Part Number = 123456987,"BA124", etc..)

(Sum of lot) summary field = total of Lot Quantity

(Sum of good) summary field = total of Good Quantity

(Sum of fail) summary field = total of CSubfail (Csubfail is a calculation field that contains the equation "sum(field1,field2)

(CRej) calculation = Round((GetSummary(sum of lot,Substrate Part Number))-(GetSummary(sum of Good, Substrate Part Number) + CSubfail), 0)

(Cyield) calculation = Round((GetSummary(sum of Good,Substrate Part Number)/(GetSummary(sum of Good, Substrate Part Number) + CRej)*100), 2)

Subsummary by c-first of month(Traling): I needed to use a subsummary instead of a Trailing Grand Summary because the calculation that is stored in (Cyield) needs to take the totals of (Sum of lot, Sum of good, Sum of fail, and Crej, and have an over all yield number, the yield number could not be the total of all the yields per product.) This part contains 7 fields they are all the same as the subsummary by substrate number Trailing

Except I have a field

(Sum Rej) summary = total of Crej.

(CyieldT) calculation = Round((GetSummary(sum of Good,sum of Good)/(GetSummary(sum of Good, sum of Good) + Sumrej)*100), 2)

My problem is that when there is more than 1 entry for a product in the month the Crej result is wrong. And so is the Yield Result (Cyield). What am I doing wrong?

##### Share on other sites

if you send me a sample of your database ( clone or some sample record to see the result ) I think I can find a solution to your problem.

abkaplan

##### Share on other sites

What is your sort order? -bd

##### Share on other sites

You said your sort is by month and product. You sort need to be by the exactly the same fields and in the exactly the same order as your subsummaries. -bd

##### Share on other sites

This topic is 8454 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,448 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 5,241 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,477 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 3,095 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,728 views
×
×
• Create New...