-
Division wrong output -- Results of division are multiplied by 4
Has anyone else encountered this problem? Tried using both DIVIDE(x, y) and x / y, results are always multiplied by 4. Odd Division Output
-
Breaking apart SUM/LOOKUP
Hello all, My team is working on breaking apart a particularly complicated SUM/LOOKUP formula that was built 4 years ago. Looking for guidance anyone may have out there. Here's what the scenario is: - 5 SUMs & 2 LOOKUPs in same formula - 2 of the 5 SUMs & the 2 LOOKUPs are traditional SUM/LOOKUP combos (so the dimensions…
-
Difference between SUM function and LOOKUP function
Hello, I am struggling to figure out how to distinguish the usage between SUM function and LOOKUP function. Could anyone explain the meaning of the "list-formatted" such as list-formatted line item/property in the context below? (quoted from this page) SUM or LOOKUP? Determining whether to use SUM or LOOKUP depends on how…
-
Level 1 Model Building certification exam: help on formulas in Employee Expenses
For some reason I can't figure out the formula set up for questions 3 & 4 bonus and phone costs by role. I am wondering if my references are mismatched. Any help on this is appreciated as I feel like I am struggling by myself here and can't ask anyone or anything to help me out.
-
Sequential projects with historical data
Hi all, First time posting to Anaplan community, I'm hoping this is a task that can be automated by Anaplan, just another one of those time-saving features that would be perfect to be built into a model! I'm struggling to create individual project numbers for both Anaplan data and historical non-Anaplan based data. The…
-
How to identify zeroes uploaded by users vs never uploaded
I searched for the posts regarding zeroes vs null values but don't think I found an answer to my question. So in module A, when people create projects they input values. These values are brought to module C as reporting values. In module B, people have the ability to upload values from Excel. The formula in module C says ,…
-
Convert list to text
Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. When I try just using the list-formatted line items, I get the error below, so it seems that if I could convert the list selection into text then I'd be fine: The 'text1' argument for the '&'…
-
How are Categories Defined?
I can't seem to find any documentation on where the standard Category values for Module Functional Area and List are defined. Is it possible to modify the options here? Does Tenant Administration have to be activated in order to modify these values? Thanks!
-
Distribution Planning Optimizer
Hello I need to solve a Supply Chain distribution planning problem through optimizer. I am solving for a small network of warehouses & depots, you can refer the same in the attachment provided. Following are the details: Objective: Minimize total costs Inputs: Demand at depots (at product level), Warehouse - Depot…
-
Booleans with different time settings
Hello I´m trying to use to Booleans to give read and write access in one of my models but one is at a quarter level and the other is at yearly level. I want the Boolean to be checked by default and change if I check one of that years quarter. This is the formula I have come up with up to now but checking one of my quarter…
-
Level 1 Exam activity 5 q4
Hey Guys, I finished entering my formulas without an error but i got the wrong answer... does the format in which i type the answer matter, for example xxxxx vs xx,xxx. I also don't know if my formulas are correct but here is what i had
-
8.6.4 Activity: Add Formulas to Margin Calculation Module
Hi, Can somebody help, I don't understand why the margin% is giving me this number. It seems to be alright in most of the other columns but for whatever reason some are not working properly. Thanks in advance!
-
Using FORMULA SCOPE on a line item with NO VERSIONS
Hi All, I am reviewing a model where formula scope has been assigned to a line item which is NOT dimensioned by versions. The line item also contains a formula. The line item can be manually edited which would suggest the formula is cancelled out by the formula scope settings. My instinct tells me that the formula scope…
-
Is "zero padding" possible in formula of Anaplan?
Hello, Is "zero padding" possible in formula of Anaplan? What I'd like to do is, for example, changing "123" to "00123" or "1234" to "01234" if a number has to be held as five digits. In other words, I'd like to insert zeros into the left side of number until the number holds a specific number of digits. I came up with the…
-
fixed row position
Hi guys, could someone tell me how i can possibly do this in anaplan? i have a module dimensioned by a list, a list of compagnies(A,B,C). this module is published in the new ux as a worksheet and im using a form to fill it in. whenever a new item is added trough the form, there is a line created with a code that rolls up…
-
Level2 1.3.4.4 Activity
I need a little assistance here. A push in the right direction.
-
Activity 6.6.3
Hi! I'm stuck on this activity. I believe my current period settings may be wrong? As my model isn't matching with the screenshot through check your work:
-
Level 2 Sprint 3 DCA INV01 3.3.7.2
I am confused about the adding DCA into Inventory. Do I need to create formula in AD02 module or Should I create an Add a Read line items also. Can somebody explain me Step by step what to do here ??
-
Optimizer Error message
Hi, I am building a small optimization model, I am getting "Constraint does not exist" error message. I am not able to identify why I am getting this error. can anyone please help? Thanks, Sourabh
-
Formula for current month
Hi, I need a formula that can give me the actual Last day of the current month. As the current month is October'21, I want to get the result as 10/31/2021. Can someone help me with the formula or guide me with a way around.
-
Lookup for top level item not working
I have an aggregates sales forecast module that only has time dimension. The sales line item in the aggregation module is doing a lookup at sales metrics module that has stores and scenarios as a dimension. When the lookup against the stores is the top level item "All Stores" it returns 0. But in sales_metrics screenshot…
-
Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08
Hi, I am having trouble importing the Data - file Employees.csv - for SYS08 Employee Details module. The data is not looking like it should and I have tried to map it multiple ways. It is a numbered list and they give that as a hint, but still not making sense to me. Can someone please help?
-
Level 1 Lesson 8.5.3
Hello I have been stuck on this activity for days now, I had searched the community for similar issues but could not find any, my mapping on G3 and P2 doesn't automatically map and it causes an error,
-
Any straight way to know the start month number as per Current FY?
Hi Friends, is there any formula / straight way to know the month number of the Current Fiscal Year? e.g. if the CURRENT FISCAL YEAR in Time Setting is as below Then Apr'2021 is first month of FY22. How to calculate like below? TIME SCALE --> Apr May Jun Jul ...... Mar LINE ITEM --> 1 2 3 4 ...... 12 Please suggest!
-
Unable to open my existing Models in my Workspace
Hi Team, We are facing issues while opening my existing Models in my workspace, last 3 hours back i was able to access my Models but now i'm unable to access. Could someone please help me here. We are aware that we have scheduled Platform Maintainance activity in next couple Attached the Error screen for our reference.…
-
Distinguish RANK formula starting value
Hello, I am wondering if there is functionality which would allow ranking based off of a specific starting value. For example, I have 'Reference Line Item' = 3 (number formatted). I then have my 'RANK Line Item' which includes my RANK formula. I would like the 'Rank Line Item' to start ranking from the Reference Line Item.…
-
level 2 sprint 1.4.6 actions
its getting difficult to import action in process please someone help me to understand this
-
2.3.11.3 Create Line Chart Saved View
Hello, I'm attempting to create a line chart as a saved view. When I create the line chart, I'm asked to Publish to Dashboard, I then select Line Chart, but am having trouble saving the line chart as a view.
-
SUM weeks into Months
Hi All, I am receiving a very unexpected error when trying to SUM Anaplan weeks into Anaplan Months. The reason we are doing this is because the clients has an unusual calendar that we are not able to replicate in native settings. Therefore, we created a mapping to map weeks into the month but I am receiving the following…
-
9.2.6 Activity: Add Formulas to Margin Calculation Module
Hello, May I get help with this part. I tried to add formulas to these line items but it does not work". There is an error each time. Unit Price Growth: IF 'SYS00 Time Settings'.Forecast Period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Unit Price %) ELSE 0 Unit Cost Growth %: IF 'SYS00 Time Settings'.Forecast…
