-
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…
-
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…
-
How to identify UTF-8 one-byte spaces (C2A0)
Hi! I would like to use the Trim function to obtain up to 60 characters from the beginning. However, if the 60th character is a one-byte space (C2A0) in UTF-8, it is not recognized by the Trim function, and as a result, a one-byte space is displayed in the 60th character. Is there any way to avoid this? If anyone knows,…
-
An NPV formula that calculates as Excel's does
Description: To have an NPV formula function that calculates NPV exactly as Excel's period-based NPV formula does. Benefit/impact: Current NPV formula returns results as Excel's XNPV formula does (using elapsed days instead of periods). We are in a position of having prospective customers and existing customers use…
-
Produce random numbers
Hi, I was wondering if there is anyway to have random number generator? Thanks
-
RANDOM() function
Function that will generate random numbers, between specified min & max values. Excel has two functions to provide random numbers: RAND() generates a decimal value between 0 and 1 RANDBETWEEN( x , y ) generates an integer >= x and <= y It may be worth considering an extension to these functions such as: RANDOM( x , y , z)…
-
Variance impact calculator
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose FP&A is often asked to calculate the impact of variables on the total variance. There is more than one way to go about it. I’d like to share a variety that uses the typical Salary/HC reporting modules output to define the contributions…
-
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?
-
Creating iterations in Anaplan
Hey Everyone, I'm trying to find a solution in an excel sheet that utilizes an iteration function that I need to replicate in Anaplan. Basically, we take the previous number multiply it by 90%, then take that new number and multiply it again by 90%. For example, FY2024 is 28,940 FY2025 is 26,046 FY2026 is 23,441 (etc etc…
-
IRR Function
I am attempting to calculate IRR on monthly loan cash flows, but my results are different to Excel and make no sense (e.g. Excel give 14.7% and Anaplan gives 418.80%) . All the examples I have seen (on Anapedia and in the Formulas and Functions app from App Hub) have annual cash flows, for which it seems to work. I have…
-
Today's Date
Hi, How can i refer Today's Date in a formula so as the values would change every day based on that days date. For e.g. if its 09th june then the formula should give result as 09th june . The next day i.e. 10th june the value should get updated to 10th june. Is there any such functionality or formula available inside…
-
Calculate once and reference | Model Optimization Team series
Hey! 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…
-
Testing in Anaplan
Hi Friends, How do we do Unit Testing and System Integration Testing in Anaplan?
-
Stop allowing copy and paste into dependant dropdowns
Hi, We have a field that is dependant and i have unticked 'Allow access to unfiltered items' However if you copy and paste a valid (non dependant) value into the field it allows it I have made it go red as a warning, but can it be stopped so you cannot paste into dependant dropdowns? thanks
-
Product Demand Allocation on Basis of Rank
Hi All, I've one scenario where volume needs to allocate by Rank. E. g. We have demand at Parent level i.e Product family level. Now in each product family we have different SKU's & demand should be get allocated by using SKU necessity in that product Family. Suppose , Product Family Level Demand = 100 and below is demand…
-
How to set a serial number based on multiple properties
Hello, I want to set a serial number based on multiple Properties. I'm trying to set a serial number based on a TEXT type key item, but I'm not getting the expected results. I'm trying to implement this using the RANK Function. If there is an implementation method, could you please guide me? The "RANK_2" in this diagram is…