Stock position on a given date

[Anonymous]

I have a table with the movement of stock to the position on .  

I managed to get the most earliest date that the informed variable, but can not get the amount in stock on the date .

Portugues:

Eu tenho uma tabela com o movimento do estoque para a posição ligado.
Eu consegui a data mais mais antiga que a variável informada , mas não pode obter a quantidade em estoque na data .

[Anonymous]

Goal is to know the balance of stock on a particular date , informed the variable.

I look at these information by opening deposit or by product , product derivation , through the collapse function or not collapse .
I have several charts / tables for this information

[Anonymous]

The expected result is to know the stock of products on a certain date ( variable ) . Having collapse or expansion of deposit , Product , Product Derivation . I need information for Storage, Product , Derivation products, can use the function to collapse or not. Always grouping and adding the data or may be in different blocks of data.

[sunny_talwar · Accepted solution]

How does this look?

Expression used:

=FirstSortedValue({<DataMovimentoPosicao = {"<=$(vDataBase)"}>} Aggr(Sum({<DataMovimentoPosicao = {"<=$(vDataBase)"}>}QtdeEstoquePosicao), DataMovimentoPosicao, CodigoDepositoPosicao),

-Aggr(DataMovimentoPosicao, DataMovimentoPosicao, CodigoDepositoPosicao))