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.
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all listβ¦
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FINDβ¦
