Problem with Sum

[#1]

Hello,

I have a problem with a Sum in my board. If I reduce my board has the article or in the month I shall wish to have for it "stock_réel" the last value of my lines which display( ex here : 525)

When i reduce i have this

anyone can help me please?

[Gysbert_Wassenaar]

Try FirstSortedValue(Stock_réel, -Date_Mvt)

[#3]

Hello, Thanks to help me but is not working

[Gysbert_Wassenaar]

Please post a small qlikview document that demonstrates the problem.

[miguelbraga]

Try as gwassenaar‌ have told but with a little difference:

=FirstSortedValue(Sum(Stock_réel), -Date_Mvt)

[#6]

A little demo

[#7]

Same results no working

thanks

[#8]

Hi,

Do you mean that the sum of the values when collapses is different  than the sum when it expands

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#10]

Thanks so much for the help