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.
Haven't used the new workflows yet so don't know it's full capability or limitations but does anyone know if I can use it to execute a FOR loop? E.g. traverse one list item at a time and then execute logic against it? I mean the bulk formula calculations is awesome but there are just some specific scenarios it best runs in…
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-