How to get totals and subtotals using Nth largest Summary

[gallobask]

I am using the Nth largest in a standard summary to eliminate some redundant data but I can't get a summary/total to work off of this field. The Nth largest summary is not created from a data field but a formula. Any ideas?

Thank you!!!!

 

[lbass]

Create a formula like this:

whileprintingrecords;
numbervar sumnth := sumnth + {@yournthlargestformula};

Place this in the section where the nthlargest is calculated. Then place a display formula in the report footer:

whileprintingrecords;
numbervar sumnth;

This assumes your intention was to sum the values.

-LB

 

[gallobask]

Ah Yes!! Create a variable. It worked. Thanks! I'm just learning as I go so I appreciate the help!!!!