running total on formula result

[jwaldner]

I have a formula like this:
DateDiff('s', Minimum({Command.StartTimeStamp}, {Command.KEY}), Maximum({Command.EndTimeStamp}, {Command.KEY}))

it returns the seconds between the start and end of an event i have.
Works great.

but i need a total of this time so I can do average time [in the footer], I get this field cannot be summarized when I try and total it and run an average. I know it's because of the Maximum and Minimum in the formula. is there a way I can add the results of this formula to a running total or something and still be able to use the formula for what I need it for. Or do I need a different tactic?

thanks!
joe

 

[pmax9999]

You will need to use variables to achieve this. Replace your existing formula with the following:

WhilePrintingRecords;

Local NumberVar s := DateDiff('s', Minimum({Command.StartTimeStamp}, {Command.KEY}), Maximum({Command.EndTimeStamp}, {Command.KEY}));
Global NumberVar SECS := SECS + s;

s

Then, in the Report Footer you can use the variable SECS to return the total seconds and as the basis for the average.

Hope this helps.

Cheers
Pete

 

[jwaldner]

Thanks, this looks like it is just what I need. I'll take it for a spin!