Totaling top records after for 1

[vblack7770]

I have created a report and used the following formulas to get the top 2 records for each group.

Formula 1 - whileprintingrecords;
numbervar RowCount:=0;

Formula 2 - whileprintingrecords;
numbervar RowCount:=RowCount+1;

Now that I have those top 2 $ amounts, I would like to get the difference between the two. Of course, using the normal sum and total will only get the sum or total for all records. I just want the difference between the two I have showing. Any suggestions?

 

[lbass]

Assuming you are comparing detail level records, you could use a formula:

{table.amt} - next({table.amt})

If you have your records sorted so that first two records in the group are the top 2, then you should be able to use this formula in the group header--if you want to display the result at the group level.

-LB

 

[vblack7770]

You Rock!! I would have never guessed to use the Next function as I have never used it in the 6 years I have been doing reports. Thanks so much!