I've created a report with 3 columns.... Daily Count, Running Count, and Identifying condition (number)
My Running sum variable is: =RunningSum([v_Sales Count];Col;([v_Grid Number]))
I want it to reset each time it finds a Grid Number in column 3
It seems to have worked the first time, then when it reached the second grid number it reset as expected but the next the running sum after that is inclusive of the data prior to the reset? I want it to include the data from the reset forward to the next grid number.
I'm somewhat of a novice and cannot figure out what I am missing or doing incorrectly. Any help would be appreciated.