-
Boolean Automate
Is it possible to make the boolean automatically uncheck itself based on date provided from another/same module? For e.g. In the picture, date is set to be 7/18/2024. How to make Q1 FY24 uncheck and let others stay checked?
-
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?
-
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…
-
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?
-
Best practices to clean up models (especially Actions)
Hi everyone, Trying to get some ideas and best practices from this great community on how to clean up unused fields in Actions. I recently deleted some line items that I was no longer using. There was nothing in the "Reference by" column so it made sense. But they were linked to some Actions to Spoke models and I ended up…
-
Produce random numbers
Hi, I was wondering if there is anyway to have random number generator? Thanks
-
Random number generator
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
-
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…
-
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?
-
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?
-
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?
-
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…
-
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…
-
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.
-
Level 2- Sprint 1- 1.3.6
Hey everyone, I am hoping someone would be able to provide some clarification for me. I am on lesson 1.3.6 of Sprint 1 for Level 2 and it states that the following items need to be in the saved view. What are the subset line items? "Include: Code, Parent, and subset line items" Thank You, Laura
-
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…
-
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.
-
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?
-
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
-
Calculating in a ragged hierarchy?
Does anyone know how to do a calculation in a ragged hierarchy which returns to the level of the hierarchy?
-
How to sync a selector field with input grid in anaplan
How to sync a selector field with input grid in anaplan
-
Ragged to Balanced Hierarchy
Please can someone give the step by step points in an easy way to convert a Ragged Hierarchy to Balanced Hierarchy in Anaplan. Thanks!
-
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…