Hi All,
Can you please help me in populating the attached years by formula , where I am not using Timescale in the module and my
Mapping Year (line item) format is Year.
CHRT** and YR** are my two dimensions used here.
Hi, @MadhabikaM
It may be helpful to use cumulate function along with line items.Please see this anapedia in detail.
https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/CUMULATE.html
And here is an example of Year adding.
I hope this could help you.
▼See CUMULATE('Number_1', FALSE, CHRT)
If you don't set the current period, you may have to choose 'initial_year' manually.
▼Here is the result.
Regards,
Taichi
Thank you Taichi, this really helped.
Madhu
Hi, I'm trying to trigger a workflow template from UX as an end user and it fails See below The context: I've got my hands on Anaplan Workflow and testing some stuffs and it's suitability on our existing business processes. We already have a Price approval process configured as a custom workflow driven by booleans and…
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…