Math in Subsummary

[sgonzo]

Excuse me for being dense.

I have three fields, Subject, Number_One and Number_Two.

I want the max for these two number fields summaries at each change in subject.

So I created two summary fields Summary_One, Summary_Two, each set as Max of those number fields.

When I place these two fields in my subsummary by Subject, I get correct numbers.

Then I tried adding them with another calculation field Added_Number = Summary_One + Summary_Two.

However, when I place this field in the subsummary, it do not get what I expect. I get a much larger number, the source of which I haven't found yet.

Please let me know my fundamental misunderstanding about subsummary and a calculation field based on summary fields.

Thanks again. Just when I think I've figured out this program, I find something that doesn't make sense to me.

[RalphL]

You need to use the GetSummary function to do math with summary fields.

[sgonzo]

The light bulb over my head is now illuminated! Thanks.