Hi, I am trying to make this mapping work in the best way possible. I have 3 criterias: RV1 Revenue, RV3 Revenue, Product Class. I need to have, as a final outcome, the same Revenue BU of the mapping …
Hi, We have 2 modules - a) SYS Module Dimensions - 1) List A (have numbers 1,2,3,4…,so on) 2) Line Items (various line items like region, status, name, etc.) b) Time dimensioned module Dimensions - 1)…
Need to pull text out of a string. Starting from the beginning but going varying # of characters. Last character will always be immediately before an underscore. So in Excel I could use the TEXTBEFORE…
I want to change the format of the column header to be the actual date in format MM/DD/YYYY. A user in another country set everything up in format DD/MM/YY and I want to change it.
I am trying to Create an Product Assortment List based on 6 different dimensions, but I just want to create the elements for which I have information (an Input from the user). The problem I am facing …
Hi I've got one module with data - timescale by quarter and 2 lines: Early repayment period - quarter format Early repayment date - date format Then I've got another module, no timescale, with 2 lines…
Hi all, I am facing an issue I'm pretty sure many of you already have dealt with. The columns Cost Center, Responsible, Employee Name, Labor Cost are line items. I wish I could show the cost center, r…
Hi Anaplan community, I need help setting up a filtered view to only display list items with value in any of the time periods in the selected Fiscal Year. And by any, I mean Q1 or Q2 or Q3 or Q4 or FY…
Hi, I am trying to build an import which should take the values from a month to the next one, in order to create a baseline the user would then modify as he pleases. Once he's done so, he should then …
Hi all, I have a few questions on the UX expereince dashboard How do i replicate the filter exactly like the example? I think there are no SKUs in the exception summary module (first table - New York/…
I got a circular reference for the below action. Redirect the formula for this line item that currently references the Suggested Order Amount for the Month line item to the Final Shipment Amount line …
Hi Anaplan Experts, I'm trying to calculate the re-balancing of stocks from one store to another based on the logic below. Step 1: Rank Supplying Stores based on their available stock to give (OUT) St…
hi all, I am trying to get the region for the employee and used the following formula What's the issue with it and what's the best practice of getting the formula? Thank you! Best
I have an issue when I change a scenario in modules with common dimensionality. Example: In the case of modules A, B, and C with a common dimension (e.g., Cases). The List Cases considers Cases 1, 2, …
