I have the following line items- A,B,C. I need to create a new line item D which should take previous quarter values if C=0. PFA screenshot.
@tampara.dora
Since the module is set at quarter, you can use the PREVIOUS function.
If C<>0 then C else PREVIOUS(C)
Make sure you set the first condition as the most likely. If C is most likely not zero then that should be first like the above example.
Aha! a year to year approach. Love it.
In that case use OFFSET. Go back 4 periods.
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…
