Hrs Label is a calculated field based on the Hours field it is next to?
Hrs Sum Label would be based on the Hours Sum field?
I show hours each day in the body of the layout. In the sub-summary I sum those hours. In the body I use this calculation:
If(ST Hours > 1; "Hrs.";If(ST Hours = 1; "Hr."; ""))
ST = Straight Time
The calculation works great in the body but not in the sub-summary. If the last day (Friday) I only worked 1 hour, the body would show "1 Hr." as it should but if I had worked 33 hours that week the sub-summary would show "33 Hr." It seems to follow the last data (Friday) in the body. If I change the last data (Friday) to 2 hours then the sub-summary will show "34 Hrs.". If I did not work on Friday, the sub-summary will show "32" with no text.
As DavidAnders stated above, you would have a different calculation in your sub-summary. You don't state all your field name, but you should have a summary field that totals ST Hours for the week. You would use the summaryST Hours in your calculation for the sub-summary.
In my sub-summary the ST Hours are summed up for the week in a field called "Weekly ST Subtotal". The actual numbers add up perfectly. However, the text doesn't work. I am using the following calculation for the text in the sub-summary: If(Weekly ST Subtotal > 1; "Hrs.";If(Weekly ST Subtotal = 1; "Hr."; "")) In the body of the layout it works using: If(ST Hours > 1; "Hrs.";If(ST Hours = 1; "Hr."; "")). Why won't this work?
To access the subtotal shown when you put a summary field inside a sub summary layout part in a calculation, use the getSummary function. Specify the same break field in this function call as you use for the "when sorted by" field in the sub summary part setup.