I would like to store last year actual value in version. So my version willl have Actual, Last Year and Act vs LY Variance.
Can I achive it using formula in Version setting?
Thanks and regards,
Maung Maung
Hi Maung Maung,
Using a Version to come up with a variance, though possible, will take up A LOT of workspace.
I would prefer to understand more about your business requirement, before coming up with a suggestion; but at the mean time, below is a suggestion using line item formula and formula scope.
The results are:
Thanks,
LipChean
Hi Lip Chean,
Thanks for the suggestion. I want to achieve account and version as cross dimension. Otherwise, I will have to another line item for each account. The screen shot is the sample.
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Hello everyone I am going through an issue with security when logging into Anaplan via power point add-in. I am a workspace administrator and SSO user. But once I installed add-in for power point, I am not able to login. I am using Universal Login (default) connection and it asks for user name and then a password (not…
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
