Multiplying Summary Field

[FileMakerHarry]

Hello Board.

I have a Products table with ProductCode, ProductGroup and ProductTime in it.

I have another table that logs product being inspected. My report details who has inspected which ProductCodes, based on Product Grouping and does a Count of the ProductCode, so I get:

Product Group 10/ProductCode 12345/ Total 22

Product Group 12/ProductCode 54321/ Total 9

etc etc

What i want to do is take the ProductTime number and multiply it by the Summary Total.

So ProductCode 12345 has 12.34mins (decimal time) per item. So I'd want 12.34*22.

Then, I'd like a GrandSummary on the bottom of my report.

Do I need to build a ProductTimeSummary field in Products Table and then set a calculation of ProductTimeSummary=ProductTime*ProductCodeSummary?

I've tried this and it doesn't work. What approach should I take?

Thank you!

Harry

[comment]

I believe both the calculation field and the summary field need to be in the Log table? Or do you want this to be an attribute of Product - thus taking into account all (related) log records, and updating as new log records are added?

[FileMakerHarry]

Hello again,

I've put a summary field for JobNo into the table, and also a JobTime field, which is a lookup from the Products Table and a calculation of JobTime, which equals JobNumberSummary (a COUNT) * JobTime.

The results I'm getting, though, are hugely bigger than they should be. For instance, one JobNumber has a summary of 2 and a JobTime of 34.38 but it returns 8079.03 as a result.

I only want it for a report - if I can just run a search for whatever dates I want and then it goes and finds the information, that would be better than storing all the information and it updating all the time. It is historical data.

[comment]

I am still a bit vague regarding the situation. I am guessing you want to multiply a sub-summary value by a factor. If so, you must use the GetSummary() function.

[FileMakerHarry]

That sounds like it will work!

Thank you again for your help and patience. I have only just started writing scripts and although i thought i understood the granular nature of scripting, there are other functions, such as moving to fields, selecting fields etc, that i had presumed were built into other functions. They aren't so I need to learn more about scripting functions.

However, I can't learn them all, so I have decided to learn them as I go. Eventually, i will have a toolbox of functions that I can understand and work with easily.

[FileMakerHarry]

If I use GetSummary, do I then need to put that result into a variable?

I inputted:

GetSummary ( KambanSummary ; KambanSummary ) * StandardHours

but it's still returning the value of TotalFoundRecords * StandardHours field, rather than the line by line summary amount.

You presume correctly; my report has shows:

JobNumber OperatorPersonName Quantity

The quantity is a Count of the number of the JobNumber. I then want to take "Quantity" and mutiply it by the "StandardHours" value in the Product Table field (which links from JobNumber to ProductCode to ProductTable).

Sorry I'm not totally clear.

Harry

[comment]

GetSummary ( KambanSummary ; KambanSummary )

This is NOT a sub-summary value. To get a sub-summary value, you must use the breakfield, e.g.

GetSummary ( sTotal ; JobNumber )

will return the sub-total for each group of records sharing the same JobNumber (provided the records are so sorted).