Divide data by 6 while loading file-based integration
in Planning
Summary:
We have a requirement for file data load where we need to load half-yearly data into level 0 periods by dividing the data by 6 on fly. Is it possible to do this in Data Integration within EPM Cloud while loading?
Content (please ensure you mask any confidential information):
We are getting half yearly data in a file which we need to load by dividing the data by 6 and load into respective level 0 periods.
Eg: In 2025H1 File, If the expense is 3000, then we need to load 500 in Jan-25 to Jun-25 (3000/6=500).
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0