Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Accepted Solutions
How does this look?
Expression used:
=FirstSortedValue({<DataMovimentoPosicao = {"<=$(vDataBase)"}>} Aggr(Sum({<DataMovimentoPosicao = {"<=$(vDataBase)"}>}QtdeEstoquePosicao), DataMovimentoPosicao, CodigoDepositoPosicao),
-Aggr(DataMovimentoPosicao, DataMovimentoPosicao, CodigoDepositoPosicao))
Making new tests to the data, I noticed that some items are not correct. The following example.
I guess this is not a good example because in this case my earlier provided expression seems to work well. Can you provide another example where my expression is causing an issue for you
What is the expected output based on collapsing and non-collapsing of the chart? Provide this based on two set of different selections because I am still not able to understand the issue 