-
ALM related question
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 section headed “Data Source Changes”. I made one change to the actions to add a new import action changed it’s sequence to the…
-
REP02 Size Margin Report
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 an error. Could someone help me with the same?
-
8.6.4 Activity: REV03 Margin Calculation Error
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 someone guide me on what I am doing wrong I am attaching my numbers screenshot of what I get for output and the blueprint view.
-
How to add unique Serial number to a text string/text key with more than 60 characters
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 module with more than 30 columns which makes key larger than 60 characters so unable to import it as code in any list weather…
-
How to Prorate Weeks Across Months in Anaplan?
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 week: Feb 3 (Sunday) Current Value: Start week: Jan 1 (Sunday) End week: Jan 21 (Sunday) How can I prorate the weeks in Anaplan?
-
formula to get total salary by role and region
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 difference, my formula is not correct. any advice?
-
Selecting the Time to import data from other model - edit prompt
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 import. The year that I need to import does not appear in the Time dropdown list of the action prompt. I checked the modules…
-
How to Substitute out Quotes
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? It appears anytime I try and reference a " anaplan recognizes that as a syntax and not a character.
-
Incorrect decimal placement importing from csv file
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 places for some entries, but some entries are rounded to 0.dp where the two d.ps are ".00". Anaplan is incorrectly putting…
-
Calculate Space Utilized depending on Format and cell count
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 calculation explaining how size is calculated using different format. Thankyou
-
Version label question
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 module, screenshot shown below. This works fine, other than ideally in the report we would have the Version 1 and Version 2…
-
Time Dimension Sum For Reporting
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 below I used the POST formula: Amount: XX Week Count: ROUND(('Date + Count' - Date) / 7, 0, DOWN) POST: POST(Amount, Week…
-
Get Data From Combination to List item to Line item
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. Application is PRoduction List Tried ComboApplication colume= SYS module Application but not returining 0
-
Get Data From Combination to List item to Line item
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.
-
How to sync a selector field with input grid in anaplan
How to sync a selector field with input grid in anaplan
-
Level 1 Exam. Correct formula to calculate the totals by region and roles.
What is the correct formula to see the result for items below by Region and By Role?
-
One to many mapping
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 from SKU A to SKU B and SKU C, who have 500 and 200 units sales history of their own, respectively. So after the…
-
I have an input module where I need to enter value (%) and it should sum up to 100%
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 distributed like in Breakback. Please suggest.
-
Filter the Hierarchy Level
Hello all. A few days ago I saw a "How I Built It " video regarding the Hierarchy filter which taught me how to use Ratio Summary for filtering . I wanted to replicate the same structure but here is the thing. I created a module for filtering Group level ( higher level ) or Product level ( Lower level ) like the picture…
-
Workspace
Hi Community, Anyone have idea about 90 days free workspace. I mean what about after 90 days. Is it chargeable or it will discontinues after 90 days