Getting a percentage from a Sub-summary/TrailingGrandSummary

I have a report with 4 Sub-summary leading, 2 trailing and 1 Trailing Grand Summary

it is a payroll report by divisions.
Job Group
Job Number
Cost Code
total Job Number
Total Job Group

I can get a percentage of Cost Code:Job Number/ Job Group in the Job Group Trailing Summary, but I can't get the percentage for Job Group / Grand Total(all job Groups)

not sure what I need to tell someone, so many see the attached report
20131024105339870.pdf
CRshieldAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
What have you tried?

Are the existing percentages summary functions?

Have you tried copying them and inserting into the appropriate group header?

mlmcc
0
CRshieldAuthor Commented:
in the sub-summary trailing I have put GetSummary(PayTotalSum;Projects::JobGroupCode)/(PayTotalSum) to get the % of JobGroup to grand total of payroll  -  it comes up zero.

I can get the % in the job number sub-summary trailing
GetSummary(PayTotalSum;JobNumber)/(PayTotalSum)

I am assuming that PayTotalSum is not properly coded
0
mlmccCommented:
What reporting tool are you using?  That doesn't look like Crystal Reports syntax.

mlmcc
0
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

CRshieldAuthor Commented:
filemaker pro
0
CRshieldAuthor Commented:
not sure what you are talking about
0
mlmccCommented:
Your question was listed in the Crystal Reports topic area and isn't about Crystal.  That  is why I saw the question and commented initially.

mlmcc
0
Will LovingPresidentCommented:
It appears that you're not actually using Summary fields, you're using the GetSummary() calculation which is useful and can produce similar results in some situations but is probably not what you need here. You should be using Summary fields instead of the GetSummary() calculation.

A Summary field summarizes a specific field over the range indicated by the sort order for the sub-summary part or for the whole report. You can use the same sub-summary field for the same column in all parts of the report including the Grand Summary. When you create a summary field, you specify the field to summarize and the type of summarization (Total, Avg, etc.).
0
CRshieldAuthor Commented:
I am new to filemaker formulas, sub-summary, etc.  I am use to Crystal reports.

What you are saying I am not understanding. Is it possible to give me an example?
0
Will LovingPresidentCommented:
FileMaker has a number of different field types include Text, Number, Container, Calculation and Summary. You are using a Calculation and the GetSummary() function where you should be using a Summary Type field.

For each of your columns that you want to total in the sub-summary parts, you will need a Summary type field to summarize the amounts. For example, your TOTAL COST field needs a Summary field that summarizes the total of all the values preceding it. I usually give Summary fields a name very similar to the name of the fields it's summarizing, so if you have a field called TOTAL COST I might name the Summary field either TOTAL COST_Sum or TOTAL COST_S or SUM_TOTAL COST.

On a separate note, if your field names contain the percentage sign or certain other characters that are also mathematical operators (+, - , / , %, etc.) then calculations using those fields may fail. Avoid using them as in %2 TOTAL PAYROLL and do not start field names with numbers either.
Summary-Fields.fp7
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Will LovingPresidentCommented:
Comment ID: 39601713 provided a complete answer including an example file I created specifically to answer the question. The author of the question didn't response but the answer is complete.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.