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.
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…
