daylaking
3 hours agoNew Contributor
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 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?