The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

osdevadmin's avatar
osdevadmin
New Contributor III
2 years 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
2 years 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