Source: Migrated from Champions I asked this question from OneStream
staff at the Splash conference and OneStream support. I thought perhaps
someone in this group has run into the same issue: The standard that
appears to be used for calculating FX do...
This worked. You showed me something different when working with
variables. Usually I see variables used like this:api.data.calculate
(script & "= 0* "& script, "A#IncStmnt.Base.Where(Text8 Startswith
VarPercentofSales)",,"O#Forms")Instead the script...
I figured out how to do this correctly. Note: our fiscal year runs from
Nov to Oct. November is the 1st month of our fiscal year. I calculated
each of these in a separate flow member:YTD balance X Closing rate
(FX_Activity_Closing_rate)- Periodic bal...
I've tried this, but I'm not following how to do this. I have several
accounts where I only want to clear the Forms data. I need the forms
data cleared for all the accounts where Text 8 Startswith
VarPercentofSalesThis was the code I tried: Dim scrip...