Forum Discussion

osdevadmin's avatar
osdevadmin
New Contributor III
9 months ago

"YTD" like calculation but for custom periods

I am writing a member formula/dynamic BR where i have to get 'YTD" like cumulative members but instead get it from month 7 onwards i.e. if i want to get cumulative data from month 7 onwards, i wrote ...
Finance
osdevadmin's avatar
osdevadmin
New Contributor III
9 months ago

This is the code that gets cumulative number from specific month its very rough so don't like it:

  For monthIndex As Integer = 1 To 6
                cumulativeAmount += api.Data.GetDataCell("T#" & fiscalYearShort & "M" & monthIndex & ":" & filterString).CellAmount