-
Auto Code Generation
Hi all- I'm trying to automatically create budget codes after a new expense has been entered via input grid on a UX page. Overall, I'm having trouble generating a numerical sequence after the other parts of my concatenated code. I've so far been using RANK(1, DESCENDING, SEQUENTIAL) but having it skip by 15 every line.…
-
Difference between custom view and saved view
Hi, Could anyone please tell me Difference between custom view and saved view. While designing UX which should we have to prefer. Thank you.
-
How to lookup a value from a source with no time
Context * My Destination module has the following dimensions: (1) Employee ID (2) Line Items (3) Time * My Source module has the following dimensions: (1) Movement Code (2) Line Items* Employee ID is a line item (List) * Effective Date is a line item (Date) Goal * In the destination module, populate an employee's job level…
-
Look up for future periods
Hello, What's the formula for looking up only future periods? In our module Professional Services Forecasting, I have actuals up to and including current period and blue inputs for forecast / future periods. We then have a module that groups various job codes called Professional Services Profitability. This already splits…
-
Data from Line Item Subset back to original line item
Hi, How can i get back the data from Line item subset back to the original line item? I used the LIS as my dropdown to another module and i want to consolidate back the data from the dropdown to my main module. Thanks, Tom
-
Regarding 80000 Character Limit in Mailto function.
Hi, Can anyone please clarify whether spaces and newlines are counted as a character in the 80000 character limit in browser? Thanks and regards, Aakash Sachdeva
-
Model Architecture and reporting stages in anapalan
i am learner i want to know that the Architecture and reporting stages in anaplan, i was totally balnked seen this questions. help me out on this.
-
Looking up Day of the Week list for a LI in a different module
Hi, I'm trying to be able to look up a total for all the individual days of the week from my historical data. i.e, I would need to look up all the Mondays in the Month of July and sum them together. I have weekdays as a list but I'm getting a error message when I try to use LOOKUP, SELECT, or SUM. Please advise. Blue Print…
-
Architecture of the model stand alone model using ALM?
Hi I am learner till i have faced issue questions in panel Architecture of ur model and what is the meaning of stand alone model. based on that stand alone how can u use ALM by steps. Another one query about reporting(stages) and permission staging. it will be helpful further to improve my skills.
-
Have a line item that does not apply to a dimension, not repeat itself
Hi guys, I am wondering if there is a way to have line items that do not apply to a specific dimension, not repeat itself within a dimension. I have a list that has another module storing details about the list and then another module which has the time dimension look at revenue for specific accounts. I have pulled through…
-
The values doesn't appear in Gridview
I use the same formula to calculate a value in a line item, it works in one module (Sales Qty - Motor) but it doesn't work in other modules (Sales Qty - Mobil and Sales Qty - Truck). I use different subsets from the same list for each module. Blueprint of Module 'Sales Qty - Motor' Gridview of 'Sales Qty - Motor' I use a…
-
Convert Months to Quarter
Hi, How can I sum my months to get the quarter value in another module? My source module is using month, i turned off of the summary SUM for Time. (to save space) My target module, i want to get the quarter value of my source. Thanks, Tom
-
Which filter will have most optimized result?
Hi @MarkWarren and Anaplan Experts, Is there performance impact on filtering in below scenarios (assuming its a complicated filtering logic)? Question1:The Boolean Filter line item is a subsidiary view in a module. If this is applied does it work slower than say a Filter line item which I move to different module to remove…
-
Formula Calculation
I am writing calculation formula which I am struggle a little, hoping anyone can help me out. When writing calculation formula in Excel, we can use ( ) to group the calculation together, but Anaplan does not work the same way or am I work? Is there a way to group calculation together within Anaplan? Thanks in advance,
-
Hide rows with zeros in UX
I have a UX grid, which has a couple of dimensions. Depending on what selections they make using the selectors the grid can show rows with zeros in all columns. How can I automatically hide rows with zeros? I don't think I can link to a boolean with a formula like 'Show = Actuals <> 0' because the selection can change (if…
-
Version
Hello Community, I have one module with version as dimension. In resultant module no version dimension is used How it is possible to flow value to resultant module..... Thankyou In advance Regards, JEEVAK
-
Trying to look up a LI for the previous 6 month average
Hi, I'm trying to look up a LI for the previous 6 months average using a TIMESUM. The formula is working but no numbers are appearing. Not sure why the numbers are not appearing. The formula is below. Thank you
-
What is the major difference between Anaplan connect and actions
I want to know the main difference between using of anaplan connect and actions. What is different between production list and production data. Please give me the information.it will be helpful for me.
-
What is the best function on the below use case: TimeSum or MovingSum ? (For best performance)
Hi, Generally it is suggested to use the TimeSum function if my target is not dimensioned by time. If my target is dimensioned by time, it is better to use MovingSum. But MovingSum doesn't allow start period parameter other than the number data type. What can we do if my target is dimensioned by time and my start period…
-
Mapping Module no time dimension to time
Hello, I have a csv import that is not dimensioned by time and date in the same cell. It can not be changed for a monthly process import. I am 90% of the way there. I created an import module (not dimensioned by time) and a reporting module that is dimensioned by time. I am able to pull in the data to the reporting module…
-
Text Functions
There should be a function to convert Date to Text -- call it TEXTDATE(x)
-
Formula error when trying to remove 'Use Switchover'
I have a group of calculated line items that I want to remove the 'Use Switchover' functionality from so they don't pull in Actuals data. However, when I try to untick the box in blueprint mode, I get an error message saying that the formula is invalid. Would be helpful to understand the connection between formula and 'Use…
-
How to calculate within the list items to get the maximun of the items from the first to current?
Hi everybody! Need help to do the calcution within the list. Here is a list with items(#1,#2,#3,...), and properties of Input and Output. The Output is supposed to be the maximun value of the input from #1 to the current item as below table. Anyone has solutions about this? I found it difficult to calculate list…
-
Line Item Subsets and Summaries
I'm running into a curious situation where I'm trying to use the Summary of a module that includes a Line Item Subset downstream in another module. I'll walk through the situation below. I built a single module to drive my line item subset, and I created a "top level" or summary item: I created a line item subset that…
-
calculation
Hi experts I have use a list for time dim. and i considered four week in every month . i just want that in first 3 week there is the 7 days in the week and in 4th week there should be rest of day in that particular month . i cant get how we can do this when we used time dim. as a list . suggest me that process I have also…
-
Modeling advice: How to build item level discounts for set time periods
Looking for help and advice on how to build out a discount function in our model. My company manufactures products and sells them to stores, for this example let's say our customers are Target and Walmart. Our business will give special discounts on specific items (~10 items) for specific time periods, like May 2nd through…
-
modules properties documentation
I am unable to find Anaplan documentation on some module properties like user list, parent, is summary, code, brought forward and start of section and their use cases . It would be great help if anyone has link on documentation related to these properties and ideas on their use case.
-
How to do Excel Search in Anaplan
Hi Anaplanners Has anyone built an Excel Search function equivalent in Anaplan? What I would like to replicate is: 1. Client has a text mapping table (screenshot 1) which maps Strings in Column B to their expense classification (Column C & D) 2. SAP extraction which contains a column called Text (screenshot 2) , Column H.…
-
Count the number of users using User list for every months.
Hi All, I would like to take a count of the users using the list Users for every month. I have a module with: Row: Users List Column: Time(Month) Line item : Number(whose formula is 1) I need to sum the number all all the users for a particular month for eg for Jan sum of users can be 74.
-
How to ramp up to understanding an Anaplan ecosystem
Hi All, What are best practices / tips to ramp up to an Anaplan ecosystem. I received my Model builder certificate and have a good grasp of the system terminology. I recently was brought on in the middle of an Anaplan project and having difficulty ramping up to what all the build activities that are happening are. My…