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

OlofA's avatar
OlofA
New Contributor II
2 years ago
Solved

Formula for same period previous year

I'm trying to write a business rule creating a KPI which returns the value of an account for same period previous year. I already have a working business rule creating a KPI which returns the value...
Finance
  • RobbSalzmann's avatar
    RobbSalzmann
    2 years ago

    This should do it:

    Dim currYear As Integer = api.Pov.Time.MemberId
Dim lastYear As Integer = api.Time.AddYears(currYear, -1)
Dim prevPeriod As String = api.Time.GetNameFromId(lastYear)

Return api.Data.GetDataCell($"A#38999:T#{prevPeriod}").CellAmount

     

OlofA's avatar
OlofA
New Contributor II
2 years ago

Thank you for replying!

When compiling Business rule to check syntax I get the error message"Value of type 'Member' cannot be converted to 'Integer'." for the following row:

Dim currYear As Integer = api.Pov.Time

Do you know what the problem could be?

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    Apologies!

    I left off a bit:
    api.Pov.Time.MemberId

    Dim currYear As Integer = api.Pov.Time.MemberId