Keep only max date on the result

[bentley32]

Hello,

This is my code and a picture of my table

Rangeavg(below(Total SUM(IF(M_ENC_SINCE_PEC=0 AND M_SINCE_PEC>0,ENC,0))/SUM(MONTANT),1,6))*sum(CONFIE_PEC)

 

I need to keep only the result the latest date of the result since it will be reused in another calculation

Thanks

[bentley32]

No one ? 🙂