By Default display max date values but upon diffrnt date selections need sum of selected date values

[su88rao]

Hi ,

I have table which displays max date values by default. I have given expression as max date id by using calendar.

Requirement is now to display the above default as is, but when multiple dates are selected frm date filter for eg: if its 5th today and data displayed of only 5th and if date filter has 5th aug 4th aug and if both the dates are selected thn my table value should sum up  and display those values. 

i tried using if conditions but its not working

=if((DateID) = max(DateID),

Sum({<DateID={$(=Max(DateID))},Year={$(=Max(Year))}>}amount),

Sum({<Year={$(=Max(Year))},Month={$(=Max(Month))}>}amount))

please suggest where i am goin wrong

can anybody help me out on this

Thnks 

[miskinmaz]

Instead of a mentioned if condition try to use the below condition:

if( getselectedcount(DateID)>0,...