-
Put the value of a selector on a UX page in a line item
Hello, is it possible to put the value of a selector on top of a ux page(in this case it is a certain KPI) in a line item? If possible, I would like to use that selection as a lookup in a line item subset to calculate the Compound annual growth rate of that value. I can do this via a field that feeds a line item but then…
-
Import error: invalid name
Hello, I am trying to run a import into a list in order to update the item code as per what the user inputs. However I get this error: This is the module view I am importing . I want "New VAT Number" to be the new item code: Here is the action: What is wrong? Thanks, Luca
-
Is it possible to have a chart with a dropdown selection to show either weeks, months, quarters?
For example, if I have sales numbers w.r.t to time, however I want a single chart on front end that has a dropdown selection to switch between lets say 6 weeks, 6 months, 6 quarters as 3 options, how can we achieve that?
-
Automate model copy
Is there a way to schedule or automate the process of copying a model?
-
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