Forum Discussion

daylaking's avatar
daylaking
New Contributor II
22 days ago
Solved

Feb Actuals divided in half to import to Jan

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 Fe...
  • JJones's avatar
    21 days ago

    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.