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.
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to getβ¦
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made toβ¦
