Good morning, The function MONTH is returning in our model the number 11 for the month of December, the number 12 for the month of January and number 1 for February. Anyone know why is this happening?…
Hi, I've made some changes to a model, and run a comparison report. The report flags I've changed some Dashboards. Not to my knowledge! Digging through them carefully they look the same, with the same…
I have Source Module like below. It has SKU as dimension and line item "Exhibition Year Season" and "Exhibition Year". Both line item are using list formatted data type. I want to lookup Exhibition Ye…
Hi All, As I was building the UX Pages and came across on roadblock wherein each time when I change country and segment in field card I had to refresh the page again to get new country and segment val…
Hi, Is there a way to drive dimension selectors from a module that has no dimensionality? I have 2 modules: Select Dimensions no dimensionality, just line items that are formatted by dimensions entity…
Hi, I'm trying to add data that has been calculated in Module A to module B. Module A: List 1 Time Line items, where one of them is: Account XPTO1 (data's format is number), Account XPTO2 and Account …
Hi All, I've been working in Anaplan Workflow, when it comes to group task I am facing with a challenge. I chose a line-item driven assignee method in the Group Task, but I was not able to assign the …
I am having a requirement, where we are having a line item being displayed on dashboard, and it is being autofilled using a formula which is pulling data from another list. Business wants to have the …
Hello everyone, I would like to move all the data in my model by a few years (Write all data from 2020 to 2023, 2021 to 2024…). For that I tried using Bulk Copy, but I can only copy individual months …
We have a process to import live orders, and it takes a little time to import the data, it is used up to 7 staff members, and as they are working from home a great deal they sometimes all run the proc…
I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
Hi All What is the best way to calculate a 12 month run-rate formula in Anaplan. Below is the calculation I used but am not getting the right figure. Also 0 used MOVIMSUM(Actuals, -12, -1, AVERAGE) bu…
l Line items: source-target ok period: source-target ok sales group: source-target ok product group: source-target ok order type: list exists only in source - OrderTypeTotal -value should be transferr…
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by ti…
Formula for Final exploration drilling (Dryhole) in excel is - Basically IF the first line items current year value is <>0 then then sum all the previous year and if the sum of all the previous year i…
I understand how synchronization on selecting a list on grid works, I am trying to see if I can make it work on multiple dimension. eg, if I have a grid with list on my row as well as column. Is it po…