I created a report that I was wondering how I could reset a running total with a missing date. Example of the report is follows.

Group by Name

02/18/14    Huber Release     0.00
02/19/14    Huber Release     1.00
02/20/14    Huber Release     1.00
02/21/14    Huber Release     1.00
02/24/14    Huber Release     1.00
02/25/14    Huber Release     1.00

Running Total Sum : 5.00

I used the formula:
if ({Audit_Trail.AfterValue} ="Huber Release"
and {Audit_Trail.DateStamp} <= currentdate-7)
then 0
else 1

But is there a way to reset for the days missing (02/22/14 and 02/23/14) for a running total of 2.00

Thank you for the help!

There are no holidays or weekends. What would the formula be with the dateadd function?

in a crystal running total you would use kevray's formula

sorry about that

Edited by DBlank - 28 Feb 2014 at 6:30am