Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I want to ask you about making a set analysis that calculates the sum of stock value at "the Max Date" for each year
supposing that I have the stock value for the 2 years 2018 and 2019
i want to get the stock value for both max 2018 "31-12-2018"and 2019 "31-03-2019"
I have written a set analysis like this
Aggr(sum({<date={"=Aggr(Max(FQST_Date_Stock),[Année])"},[TypeDate]={'DateStock'},[FQST_Type]={'StockInterne'}>} FQST_Quantite_Produit*FQST_Prix_Unitaire_Quant),[Année])
but it gives me the value of Jan-2018 and Jan-2019
like in the picture :
for Jan-2019 it's the value of '01-01-2019'
for Jan-2018 it's the value of '31-01-2018' (the only date in Jan-2018 the system began from that date)
thank you for helping me cherished community 🙂
unfortunately sunny that doesn't give any result "Null Value"
I left you a private message to explain to you more the situation I have