Getting a percentage from a Sub-summary/TrailingGrandSummary

What have you tried?

Are the existing percentages summary functions?

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

mlmcc

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

What reporting tool are you using?  That doesn't look like Crystal Reports syntax.

mlmcc

filemaker pro

not sure what you are talking about

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

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.).

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?

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.