0 Replies Latest reply: Sep 16, 2017 4:31 AM by gaurav gopale RSS

    How to sum the value for specific date range?

    gaurav gopale

      Hi All

       

      I have the following field in a table of data model

      ValueType

      Budget-FY-16

      Budget FY-17

      Budget FY-18

      May-17

      Sep-17

      Jun-16

      Dec-16

       

      I also have

      AmendmentData, ValueType

      DD/MM/YYYY, Value

      DD/MM/YYYY, Value

      DD/MM/YYYY, Value

      DD/MM/YYYY, Value

      .

      .

      .

      DD/MM/YYYY,Value


      when the user Selects Sep-17 from ValueType field  , i want to sum the AmendValue  from starting month of that FY year  till the selected monthYear

      (ie from April-17 to Sept-17)


      sum(    { ?  }       ValueType  )





      Can anyone help me in this?


      Thanks in Advance