I have a Summary field called MinDate that returns the Min of a date field called TheDate.

Then I have a Calculation field called MinDateWords that returns the monthname and year of the MinDate summary field.

I want to use the MinDateWords field in a Sub-Summary that breaks on OrderID, but it is giving me the minimum of the found set, and I want the min of only the order that the Sub-Summary breaks on. I have checked the sorting and I know it is correct because the MinDate field in the same Sub-Summary is properly returning the minimum date for each order, not the entire found set.

To reiterate, the problem is that MinDateWords is returning the min value of the entire found set, not just the Sub-Summary.

Is there any way to get this to work? Or can I use the monthname function on a Merge Field? (I tried, but could not get that to work either.)

Thanks!

You need to use the GetSummary() function, when you refer to sub-summary values in calculations:

GetSummary ( MinDate ; OrderID )

will return the minimum date in the group, when records are sorted by OrderID.

Not sure why you need this, though - you could use the summary field directly and format it display the way you need.

Thanks, that worked.