Skip to main content
A
Anonymous
March 19, 2026
Question

Feb Actuals divided in half to import to Jan

  • March 19, 2026
  • 4 replies
  • 6 views

There was no Jan close, so we want to divide Feb actuals by 2 to get a Jan actuals load.  The loads are SQL from HFM and Database Whse, so it isn't done with a flat file csv.  When I looked at the Feb Import that are 1214 lines.  How can we take that Feb import, divide by 2, and import in Jan Actuals?  First thought was to create a QuickView then upload back into OneStream.  Also looked at a copy Business Rule but calculations are needed for the data.  Any ideas/thoughts?

4 replies

J
JJones
March 20, 2026

What you could do is create a new data source as a copy of the existing data source and then multiply the amount field by .5 in the (Factor Value) and then use that to run the import for Jan and Feb.  I'm not sure how your data source is setup to pull in the period though to make sure the data gets put into the Jan and February Periods.  

A
Anonymous
March 20, 2026

OK, but how to set up the amount field by .5?  All I see is a dropdown that give options.  Would the .5 go in the Factor Value field?

J
JJones
March 20, 2026

The .5 would go into the Factor Value Field, correct.

A
Anonymous
March 20, 2026

I created and copy of DataSource and all looks good.  When I go to load Jan, this is the error message.  I'm not sure what Time and Scenario needs to be changes.

 

 

Terms & ConditionsAccessibility statement