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

AndreaF's avatar
AndreaF
Contributor III
2 years ago
Solved

Using a variable in the calculate string formula

Hi, I am in a custom business rule.   I have a calculate formula like the following one, which works fine: api.Data.Calculate("A#Sales1 = A#Sales2 + 50”)   Now let say I want to declare a varia...
Finance
  • JackLacava's avatar
    JackLacava
    2 years ago

    The safest approach is this:

    Api.Data.FormulaVariables.SetDecimalVariable("Growth", 50)

    API.data.Calculate("A#Sales1 = A#Sales2 + $Growth”)

    This approach avoids possible issues with converting numbers to string - when the user executing it has a different Culture, or when decimals get truncated (hence losing precision). There is a blog post discussing it as part of internationalising an application.

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

Here you go:

Dim Growth As Decimal = 50
api.Data.Calculate($"A#Sales1 = A#Sales2 + {Growth}”)
  • AndreaF's avatar
    AndreaF
    Contributor III
    2 years ago

    This formula gives me the following error:

    "Unable to execute Business Rule 'Plan'. Invalid calculation script. Unexpected text. {Growth}."

    • Big_Rick_CPM's avatar
      Big_Rick_CPM
      Contributor
      2 years ago

      The method Robb mentions is using string interpolation. The error message you sent to me sounds like you are missing the dollar sign ($) before the literal string that tells the complier it is an interpolated string.