Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
=sum({$<Date={'$(=max(Date))'}>}Value)
or
=sum({$<Date={'$(=date(max(Date)))'}>}Value)
=sum({$<Date={'$(=max(Date))'}>}Value)
or
=sum({$<Date={'$(=date(max(Date)))'}>}Value)