I need to convert a date-formatted line item into the YY-MM format. Could anyone suggest a more efficient method or confirm if this solution is optimal?
I made some changes to our development model today and when we came to promote via ALM, the comparison report shows some item that we had not anticipated or expected. The comparison report has a secti…
Hi, I am trying to put the formula in the REP02 Size Margin Report module which is part of 8.8.4 Activity: Add Formulas to Size Margin Report Module. However, while entering the formula I am getting a…
I am working on activity 8.6.4 Activity: Add Formulas to Margin Calculation Module I have some different numbers to what are there in the screenshot shared in the lesson after Check Your Work. Can som…
Hi All, I have a transaction level file coming from SAP with Actual records containing more than 50 columns in a module. As per business requirement I have to create a text key line item in that modul…
I need to create a monthly filter for a grid that uses TIMESUM in Anaplan. I'm struggling because some weeks span across two months. For example: January (Expected): Start week: Jan 1 (Sunday) End wee…
Hello, what is the correct formula to get the total salary by role and region? in the source module EMP02, the timecard is "month" and in the target module REP04, it is "year". Aside from the timecard…
Hi, I have an action to import data from one model to another. When press to start this action I have a prompt page to select the Time, it means I need to choose the year of the budget that I want to …
I am trying to write a substitute formula that simply deletes double-quote characters Example: Text1 Start: This is a "note" text field Text2 After Formula: This is a note text field Is this possible?…
Hi, I've noticed strange behaviour when importing into a number formatted cell in Anaplan from a csv file. My csv file is directly exported from a Workday report, and the csv file contains 2 decimal p…
Hello Anaplanners, I have small query regarding size calculation, like how size of model is calculated using cell count of lineitem depending upon format used.. I would be better if I can get example …
Think I already know the answer to this question but just wanted to double check with more experienced users. We are operating with forecast versions as a list and a version selector as a system modul…
Hi Anaplan Community, I will be grateful if you can share your opinion on this problem: Below is the scenario need to solve: I need to transfer the "Amount" based on the "Collection" week as shown bel…
Source: We have combination list and its properties with QTY value Target : I am using individual list except Application.i want application value by line items. Without using Application Dimension. A…
Source: We have combination list and its properties with QTY value Target : I am using individual list except Application.i want application value by line items. Without using Application Dimension.
Hi, I have a requirement where i want to realign/ redistribute the Sales History from 1 SKU to many SKUs. Lets say, i have SKU A with 1000 units sales history. I now need to realign 400 and 300 units …
I have an input module where I need to enter value (%) and it should sum up to 100% and once it reaches 100% we should not be able to enter any more value. The values will be random and not equally di…