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