Set analysis sum first value in a series of values

[#1]

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)

[#2]

Anyone?

[tresesco]

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