Search results for query: *

Thanks Jeane I'll be away until Tuesday. I'll respond then. John

Penalty is the field in col2. It's a calculation field. I'm still getting 0.9 However, I've noticed the last state OH is missing. The loop may be exiting before the last record. Also, I've had to disable the Show Omitted script step. If you could send a sample, that would be great! I haven't...

What I have in the trailing grand subsummary is SumPenalty_cn = Sum(Penalty) This produces 0.02 What I just tried is: SummaryPenalty_cn = Summary Total of Penalty But this produces 0.9

My response Hi Jean Your approach didn’t quite work out. The field in the trailing grand subsummary produced incorrect results. I suspect because of the way the number in col2. I’ll have to go a little deeper into what I’m doing. I’m making a calculation for State Tax Returns for a trucking...

I think I'll have to move to your side of the globe. The sum is 30.42, and there are no hidden files. I will give your solution a try. John

Jeane, Maybe this example will illustrate what I'm trying to do. I have two columns. Col1 is the name of a state (input) and Col2 is a calculation field involving getsummaries. Col1 Col2 AL 0 AL 0 FL 8.53 Fl 8.53 GA 6.98 GA 6.98 GA 6.98 IN 14.91 IN...

Jean, Thanks for the reply. To get the total of all states in a trailing grand summary wouldn't the following work by modifying the break field: GetSummary(AverageIncome01 ; AverageIncome01) - GetSummary(AverageIncome02 ; AverageIncome02).

FM 8.5 adv. I have a calculation GetSummary field in a subsummary part that's sorted by State. I need its grand summary in a grand subummary part. I've tried summary and getsummary calculations but nothing works. They don't total properly. Is there any way I can do this? In general I'm having a...