reset

[jpillonel]

I create this formula to create a total on my group footer. But how can I reset this forumla when the group change ? Thanks

numbervar dur :={#R-TIME_SPENT_TOTAL-RESUME};
numbervar hrs;
numbervar min;
numbervar sec;
stringvar hhmmss;

hrs :=Truncate(Truncate(dur/60)/60);
min :=Remainder(Truncate(dur/60),60);
sec :=Remainder(dur,60);

hhmmss :=totext(hrs, "0&quot+"h"+totext(min, "00&quot+"";

Thank you !

 

[bdreed35]

Are you resetting your Running Total? I would think that resetting it would cause your formula to change automatically.

Open the Field Explorer and expand the Running Totals.
Right click R-TIME_SPENT_TOTAL-RESUME and choose edit.
Check the Reset option. It should be set to On Change of Group and pick the appripriate group if you have more than one.

~Brian