Transform expression to set analysis

[#1]

Hello,

how can I transform this expression to set analysis?

=sum( if(Date= date(DayStart( MonthEnd(Date))),VAL))

thx,

Yacine

[CELAMBARASAN · Accepted solution]

Try with this

=Sum({<Date={"=Date=Date(Floor(MonthEnd(Date)))"}>} VAL)

Hope it helps