Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Instead of a mentioned if condition try to use the below condition:
if( getselectedcount(DateID)>0,...