3 Replies Latest reply: Sep 6, 2012 9:03 AM by kochekovski RSS

    User field depended condition in expression

      Hi,

       

      I have list with dates and diagram where I need to get sum of values where date less or equal to date selected in list box.

       

      for example:

       

      I have data like this

      data.date

      data.value

       

      the list shows data.date in month format

       

      the expression in diagram I need is somthing like:

      Sum(

          if(

                data.date <= (valueSelectedInList),

                ByMonthPlan.Value,

                0)

      )

       

      If anyone know the way how to do it, please help.