2 Replies Latest reply: Sep 13, 2010 3:35 AM by Tresesco B RSS

    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.

      =sum( {<Date = {'>=$(=date(min(Date))) <=$(=min({Date} Date))'} >} MyValue)