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

su88rao — Sat, 16 Nov 2024 05:04:46 GMT

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

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

miskinmaz — Mon, 05 Aug 2019 10:21:21 GMT

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

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

topic Re: By Default display max date values but upon diffrnt date selections need sum of selected date va in App Development

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

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