Sum() where property = Max()

[#1]

Let's assume we have

Entity

{

     Date

     Value

}

How to Sum(Value) for the latest day?

=Som({<$Date=.........>}Value)

I'm still trying to understand the syntax, I tried several ways but without no luck.

P.S. Any article regarding syntax like this?

[Nicole-Smith · Accepted solution]

=sum({$<Date={'$(=max(Date))'}>}Value)

or

=sum({$<Date={'$(=date(max(Date)))'}>}Value)