Hi!
1. If your Prod Year is custom list, then create a module with custom list dimension and a year formatted line item. Fill it with FY23 in this case.
Then in target, use formula: Source Module.Data[LOOKUP: New Module.Mapping]
2. If your Prod Year is native time, then value will automatically aggregate in Target module and sum/lookup is not required.
Cheers!!
Himanshu's answer is spot on!
I would just like to add that Anaplan Time behaves in this way because each member of the time dimension is treated as discrete member - This is how the PREVIOUS, LAG etc. formulas work only with Anaplan Time. Members of a normal dimension are contiguous and can be summed against.
Hi - can't access support portal having already registered. Receive the following error message - is this an issue with Anaplan or our internal IT?
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…
