Running Total Based on Previous Row

[kamanuel]

Hello! I need to calculate running total of rows based on the balance of previous row. I have tried discussions in the community. But I find hard to make it work. Here is the basic table:

The column with red arrow is what happens when I use the following expression: SUM(SELECT(Bills Received from Courier[Verified Count of Bills],([MDSC NO AUTO] = [_THISROW].[MDSC NO AUTO]))).

[MDSC NO AUTO] is the key field for this table. I tried using the ‘<=‘ instead of just ‘=‘ it produces an error.

The column in green arrow in the first picture is the desired result. Appreciate your advice.

Manuel

[1minManager]

So the App Formula for [Running Total of Veri…] needs to be:

ANY(SELECT(Bills Received from Courier[Running Total of Veri...],[_RowNumber] = [_THISROW].[_RowNumber]-1))
+
[Verified Count of Bills]

Basically previous rows total plus this row

[kamanuel]

Hi there Simon!

Yes. Basically the balance of the previous row plus the present row.

I tried the suggested formula. This is the result as attached.

Thanks.

MANUEL S. MENDOZA, JR.
nonongmendoza@yahoo.com
Cell: 0920-938-16-71

[Sara_Bertomeu]

The solution that you need for adding the after item to the next I founded like this:

SUM(SELECT(VENTAS [Unidades],([TOTAL UNIDADES] <= [_THISROW].[TOTAL UNIDADES])))

thanks sara

[Joseph_Seddik]

That won't work for him. 

[Joseph_Seddik]

Hola Manuel,

What is the app formula for your "MDSC NO AUTO" key column?