Hi, I am trying to calculate last month & start month basis on DAT01 TestData.
For E.g.:
For list Item A: Start Month should be Nov 24 & end month as last data value.
Source Module:DAT01 TestData
Target Module: CAL01 Start & End Month
Hi @akashagarwal ,
To achieve the required output, since you need to transfer results from a time-dimensioned module to a non-time-dimensioned module, you will need to aggregate the data using a time function like TIMESUM(). For this, you can create another line item in the source module (where the data is time-dimensioned, such as "Start Date") and use a formula like the one shown below:
TIMESUM()
And In the target module, you can use the TIMESUM() function to aggregate these dates by applying "First Non-Blank" or "Last Non-Blank" logic. Define the start and end periods in a system lookup module, where you can use the PERIOD() function to achieve your desired output.
PERIOD()
I hope this helps.
Hi @Prajjwal88, this works as described. I tried using counter but this is efficient approach.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.β¦
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the nodeβ¦
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create aβ¦
