Forum Discussion

CLG's avatar
CLG
New Contributor
9 months ago

Copying or Calculating a translated currency value

Hello -- 

I'm trying to isolate a data point sitting at an Account parent with USD as the currency, then copy that value to a different account.  Then, I want to use the second account to seed another in different scenario and account structure, where it will NOT translate (plan to use flow dimension to accomplish that part).

For the first part of this, I'm trying to hold the USD value by inserting into another account.

api.Data.Calculate("A#BPA_InvestSubs_USD:C#USD = A#InvestmentSubsidiaries:C#USD")

Is something like this possible?  I'm getting an error about invalid destination when I attempt to consolidate.  Is an Eval needed instead?  What might one look like for this if so?

I'm new to OneStream - appreciate any tips and thoughts.

Thank you!

 

Finance
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    9 months ago

    You cannot save data for a Currency that is not the Entity currency using Calculate.

    If you want to explicitly trigger translation, you can use api.Data.Translate(), or run Data Management jobs to perform the translation, but to be honest, in this case there is no need for BPA_InvestSubs_USD at all; just let the system translate and pull from S#Scenario1:A#InvestmentSubsidiaries:C#USD when you need it in "Scenario2".

  • jana_seinige's avatar
    jana_seinige
    Contributor II
    9 months ago

    you have to do something like this

    if api.pov.cons.name = "USD" then

       api.data.calculate("A#BPA_InvestSubs_USD:C#USD = A#InvestmentSubsidiaries")

    End If