Set analysis sum first value in a series of values
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.
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?
