How to sum the value for specific date range?

gauravgg — Sat, 16 Sep 2017 08:31:57 GMT

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

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

topic How to sum the value for specific date range? in App Development

How to sum the value for specific date range?