Max Date for each year

[faroukfrk]

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  🙂

[faroukfrk]

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