Set Analysis

[SaggiNeha]

Hi All,

I have requirement of selecting max Date by default, else it should take selected date.

I am using below expression, right now it is giving values as per selection but bydefault it is taking sum of all dates.

Please help.

Sum(${<[COB Date]*={"$(=max([COB Date]))"}>}Amount)

[Taoufiq_Zarra · Accepted solution]

@SaggiNehawhy we use *= ? do you need any intersection ?

if not you can use this:

Sum({$<[COB Date] = {"$(=Date(Max([COB Date]), 'MM/DD/YYYY'))"}>} Amount)

change 'MM/DD/YYYY' by your defaut date format