Forum Discussion

OS_Love's avatar
OS_Love
New Contributor III
2 years ago

Culture Setting Impact on Dataload

I have couple of Connector DS and multiple Flat file DS in OS.Currently, the client wants to include Eurpoean culture for some of the users. I noticed that the dataload is behaving weirdly. The same ...
Data Integration
aformenti's avatar
aformenti
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi OS_Love,

Look out for instances on those Business rules where you converting Decimal Values to Strings for use in formulas. 

A good way to handle it is by using Formula Variables:

api.Data.FormulaVariables.SetDecimalVariable(VariableName,DecimalAmount)

To be used in formulas Like:

api.Data.Calculate("A#Acc1= $VariableName * A#Acc2")