Webi - Running Sum Not Working Correction

[former_member1084822]

I've created a report with 3 columns.... Daily Count, Running Count, and Identifying condition (number)

Example:

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.

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend you to read this overview Community Q&A, and to take our Q&A tutorial . With these tips you'll be able to prepare questions that draw responses from our members.

The more details you provide, the more likely it is that members will be able to answer your question.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

[ayman_salem]

The cause of the problem is the "null/empty" values in the "Grid Number" column.

Therefore, the "null/empty" value of the grid number for the "RunningSum" function is also a "Grid Number" value, and a sum is formed for each "null/empty" value.

Note that the total in row 3 is the sum of row 1 + row 3 "21,256 + 22,489 = 43,745" (and not row 2 + row 3 which should be 42,885)

..

To solve this problem, you shouldn't have "null/empty" values in "Grid Number"