I have created a detail function total that executes at detail time.  I want to display the result in a group footer without executing the detail function at group footer time. Right now my detail function works fine but when I put it in my group footer it add the last detail line AGAIN and displays an incorrect total in my group footer. How can I display the result of my detail function without executing it again in the footer when I want the total to display?

 

Thank you. 

 

Thank you for replying back.

 

Yes I have a variable formula called UNITS. Here is the formula I have for UNITS:

 

WhilePrintingRecords;
Global NumberVar units;
units := units + ({Command.EVECEQ} / 15);

 

I have this variable in my detail section and is working correctly. It calculates the units and keeps a running total of units until I reset it to zero on the next group header.

 

I created another variable called DisplayUnits. Here is the formula I have for DisplayUnits:

 

{@units}

 

I have it placed in my group footer. What its doing is executing my UNITS variable again then displaying the result in the group footer. The last record in each group is being executed twice instead of once. I need DisplayUnits to just display the result of UNITS not execute it again.