Problem with Sum

[#1]

I have a problem on my board the operation for sum not working:

Normally I leave QTY and I subtract every operation of movement of the result obtained previously.

Except here the problem is that it  takes me all the time the value of the original stock for the subtraction instead of the result obtained after the movements.

The normal results are  507 - 102 = 405 not 429

If anyone have a solution

[krishna20]

Hi,

Can you please share sample app. It will helps to sort out the problem.

[PrashantSangle]

Hi,

As Krishna suggest share your app or share your expression which are using.

Regards

[#4]

Hello ,

I have attached a few demo

thanks for the help

[PrashantSangle]

As per your expression logic data is correct your

Qte_Stock_Inventory is 531 and

Qte_Mvt_Sum is -102

therefore final value is 531-102=429

Regards

[#6]

I want expression for calculate:

Qte_Stock_Inventory is 531

1st qte_Mvt is -24

531 - 24 : 507

2nd qte_Mvt is -102

507-102 : 405 not 429

etc....

[Kushal_Chawda]

this is what you are looking for? see the last column

[rubenmarin]

Hi, this expression for stock réel:

Sum(Qte_Stock_Inventaire)+ rangesum(above(Qte_Mvt_sum, 0, RowNo()))

returns this:

[#9]

Hi, the expression working but if i have many "Code_Article" the expression don't calculate for each "Code_Article" and i have this error. :

I think is missing a field in expression aggr but where i don't know.

Thanks to the help

[rubenmarin]

My expression only works in a straight table, in a pivot table expanding one Code_Article will break the logic with above().

You can try if it works using 'TOTAL':

Sum(Qte_Stock_Inventaire)+ rangesum(above(TOTAL Qte_Mvt_sum, 0, RowNo()))

Remember to try expanding only one code_article, preferably in the middle (not the first or the last code_article)