Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm using this set expression to get the ingoing balance for each month and it works fine even if I select multiple Dates. But when I select multiple months the expression sums the total value for the first found value of each selected month. I want the expression to sum the first occurrence disregarding whatever Date, Month or Year selections I've made.
=sum( {<Date = {'>=$(=date(min(Date))) <=$(=min({Date} Date))'} >} MyValue)
Anyone?
Hi,
Though i am not very clear about your requirement, let's share what i have understood. it seemed that you want a single Date to be filtered which is the first occurance of your condition. if it is so, then better you use a variable to find it and then use it in the set analysis as Date= {$(#Variable)}.One more thing, would you please explain the second portion of your set analysis i.e $(=min({Date}Date)).... is it working fine?
Regards,
tresesco