-
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO
-
Use formula to integrate data at multiple levels of list hierarchy
Hello, my model has a list hierarchy of "FND01 Fund" and "FND02 Series". FND01 has a top level of "All Investments." The model also contains three modules with data values at each level of the hierarchy - Total, Fund, and Series - and I want to integrate this data into a unified report as shown below: I need to write a…
-
1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
-
How to change date format DD MMM YYYY
Hi, I have a date formatted line item (example: 4/1/2020) - this is in mm/dd/yyyy format However, i want to show as 1 April 2020 or 1 Apr 2020. How do I do that?
-
Round Function
It would be great when using the Number of Decimal Places in the Round function if Anaplan rounded to the number of decimal places asked and it stayed rounded when going up the hierarchy. The summary is set to "SUM". For example, I have five children members with a formula ROUND(Value $ * value %, 2) function. Each of the…
-
Alias Names for Time, Versions, Modules, Line Items and Dashboards
Hi Anaplan, It would be great for Anaplan to allow users to create alias names for: time, versions, modules, dashboard, list and lineitems. Thanks, Usman
-
New Function To Convert Date Format to Text Format
It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function. Best practice would dictate to split these functions out but this increases clutter and causes unnecessary calculations in models.
-
Leading zeroes in anaplan
I want to fix the length by appending zeroes :- Consider below example where i am having 3 Prod ID :- 1234 1234567 123 Below is the result i am expecting:- 0000001234 0001234567 0000000123 Generally we call this left/right padding or leading zeroes.
-
Spread Function - Divide by numbers with decimals
Hello, we are using the spread function for bookings to revenue conversion. We would like to be able to spread by a non-whole number of periods, i.e. 51.6. Currently this is a constraint on this function. Can this be changed to allow numbers with decimals?
-
Cumulate calculation but skip 1st item
Do you have any ideas to calculate this; what I need? If I make a line item called "for lookup" and use LOOKUP formula, I can do this. However I need to fill in "for lookup" manually. I simplify the case here and "Figure" should be calculated using "What I need", so I cannot use "Figure" since it becomes circulation…
-
SUM Function Example
I tried to create a simple SUM function. In a video it explains transaction as Line Item whereas I failed it as Line Item. So I tried using Transaction as a List. It worked out. Can you please let me know, if I am right or wrong? I have shared Screenshots for reference.
-
OEG Best Practice: Line item subsets demystified
Line item subsets are one of the most powerful and efficient features in Anaplan, yet one of the least understood. The COLLECT() function is probably the only “black box” function within Anaplan as is it not immediately apparent what it is doing or where the source values are coming from. In the following article, I will…
-
Create Shipping Export Module and Create a Saved View
In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format and summary method but I'm not sure if it was right. Here is the blueprint of my INV05 And here is the screenshot of the…
-
Formula change in Opening and Closing line items.
Hi Team, I needed small help to optimize the formula from Half-Year to Full-year. Current working System: If Jan 2021 (Budget) H1 Opening HC we were referring to Closing HC of Dec 2020(Actual) and IF July 2021(H2) we were referring to Jun 2021(Actual) Proposed System: If Jan 2021 (Budget) H1 Opening HC we were referring to…
-
Having boolean true for certain hierarchy levels only
I have a hierarchy consisting three levels (product/product family/total products. Similar to the one in the trainings) and I tried to do some conditional formatting on it (need to use it as other tables on dashboard have list/line item subsets in it so needed to create a consistent outlook) I thought using an if formula…
-
SUM and LOOKUP | Model Optimization Team series
Hi! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation_ Error
The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation. Kindly help ERROR: The formula for 'REV03 Margin Calculation'.Cost of Sales is invalid ;REV02 Volume Inputs'.Volumes is…
-
How do I exclude zeros from a MIN aggregation?
I am building an output module to show some statistics around account pipeline by industry. I want to be able to show the smallest pipeline. Since some accounts have zero pipeline, the standard MIN function returns zero, but I want it to return the MIN excluding zeros. How can I do this? Here's an example of what I'm…
-
Is it possible to run external Python script from UX page?
Hi, The question is about the following situation: A user makes a change to the grid and I want to perform calculations for another line item. I have the calculation formula written in a Python script and I would like the end user to be able to run it from their UX.
-
Ability to call external scripts
Hello, Is there a possibility to run external scripts from Anaplan UX Pages? I'd like to run my Python Scripts with calculation formula from UX page using for example Button is it possible?
-
Level 2 Sprint 2 DEM03 Growth Rate % line Item
For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference: The issue I am having is that I am unable to properly map the formula. Resulting in various error messages. I…
-
Commission calculation
Hi, Can anyone tell me whether the below calculation is correct or not? If yes, then can someone please clarify why the quarterly balances are different Thanks AB
-
Is there any way i can convert number to text format but still following the number format for comma
Unable to convert number to Text following comma format, Could anyone help me out of this problem? Thanks in advance
-
Current Date and Time
It would be great to have a function to get current date and time. Timezone settings could be common for all users and maintained in the settings section
-
YTG & YTD Calculation by using custom list
Hi All, I've one use case where I've create list which includes YTD & YTG as list item. Then I've create a mapping module between Time & YTD & YTG list item as shown in below screenshot. But when I am using sum to get data which is dimensioned by YTD & YTG List, result is showing 0. Can anyone explain why I am getting 0…
-
Allow the same action to run multiple times within a single process
Description of the enhancement required: Allow the same action to run multiple times within a single process How would it help your business process: There are many situations in which this would be helpful. One example Setting a production plan based on prioritising SKUs. i.e. The capacity of a production line is…
-
Build a random number generator in Anaplan
Author: Noah Jackson is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Anaplan does not have a RANDOM formula or function, but random numbers can be useful — I was interested in it for generating sample data, but it could potentially be useful for other applications such as Monte Carlo…
-
Variance Analysis With Native Versions Made Easy
When creating a model using versions, one of the first questions is, “Should I use Native Versions, or should I create a Custom Versions list?” Will I need to do version comparisons; do the comparisons need to be dynamic? With Native Versions, I can create another Variance version and create a formula, but a) it is not…
-
Converting price
I have a module called FX01 Currency Rates. It has 6 Currencies and their rates for 2024, monthly. I have another Module called REV04 Sales Volume Budget. where by customer and SKU there's an input for volume and price. The price is by SKU currency. The SKU currency is brought in a line item. I want to have a rate line…
-
Level 2 - Conclusion: Export data from INV01
I am currently working on the Conclusion for Level 2. When preparing the export saved view for INV01 Beginning Inventory, I noticed I have significantly different numbers in my module as compared to the example .csv and the screenshot from the course. I am wondering if there is something obvious I am missing, or if I need…