Problem Sum

[#1]

Hi,

I have a problem with Function "Sum"

I try to calculate "Stock UC a date" with this :

FirstSortedValue(aggr(DISTINCT Sum(Qte_UC_Stock_BDD)+ sum(Qte_PCU_STOJOU),Date_Mvt, Code_Article,Stat_2_Article),-aggr(Date_Mvt,Date_Mvt,Code_Article,Stat_2_Article ))

and

FirstSortedValue(aggr(DISTINCT Sum(Qte_UC_Stock_BDD)+ rangesum(Above(TOTAL (Sum(Qte_PCU_STOJOU)) , 0, RowNo())),Date_Mvt, Code_Article,Stat_2_Article),-aggr(Date_Mvt,Date_Mvt,Code_Article,Stat_2_Article ))

It's Ok for collapse or expand but my results is not good.

Normally subtract every operation of movement of the result obtained previously on "Stock UC a date"

Maybe anyone have an idea where is my problem?

[#2]

Thanks a lot Juan it's work perfectly

Best regards