Solved

Getting a percentage from a Sub-summary/TrailingGrandSummary

Posted on 2013-10-24
13
33 Views
Last Modified: 2016-07-10
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
0
Comment
Question by:CRshield
  • 4
  • 3
  • 3
13 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39598196
What have you tried?

Are the existing percentages summary functions?

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

mlmcc
0
 

Author Comment

by:CRshield
ID: 39598476
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 39598781
What reporting tool are you using?  That doesn't look like Crystal Reports syntax.

mlmcc
0
 

Author Comment

by:CRshield
ID: 39600190
filemaker pro
0
 

Author Comment

by:CRshield
ID: 39600300
not sure what you are talking about
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Expert Comment

by:mlmcc
ID: 39600379
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
 
LVL 24

Expert Comment

by:Will Loving
ID: 39600624
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
 

Author Comment

by:CRshield
ID: 39601567
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
 
LVL 24

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39601713
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
 
LVL 24

Expert Comment

by:Will Loving
ID: 41701808
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now