-
Unable to Dynamically change Line Items names
Hi all! I tried to follow the steps of this article about dynamic line item names change but I can't get it to work, so I would like some help on why it's not working. For context: I am building a Price/Volume/Mix analysis which I gave the end user the ability to pick which versions they want to see the comparison, naming…
-
Security: one user only allowed to update data
Hello, I need to customize a solution for one user only. In particular, I want this one user to be the only one who's able to check the "Update VAT Number?" boolean and type in the "New VAT number" cell. However, the rest of the module needs to stay editable for all the user. The UX will then display all the columns,…
-
Any tips for reviewing the Model Map?
Hi I was wondering if anyone could share with me any tips that they use when exploring a new model using the model map please? Whilst I understand the basic functionality of using the model map, I am finding it very difficult to get a good understanding of the model and the relevant modules involved, because the model is…
-
Issue with Cloudworks Scheduled Process Not Updating Target Modules
Hi Team, I am facing an issue with Cloudworks. When I run a process manually, it updates the data in the target modules. However, when I schedule the same process in Cloudworks, it runs successfully but the data is not copied to the target modules. There are no Selective Access or DCA applied. Is anyone else facing the…
-
Circulance References Issue
When apply formula on Confirm Purchase Order Receipt line in the INV01 Inventory Ordering Module i'm getting error
-
Convert Date Format
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?
-
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.