-
Another Question
Good Afternoon, I am yet getting another error... Data type mismatch: format other than LIST or DATE being referenced as a relation Anyone what this mean? Thanks Tony
-
Aggregate value of lineitem
Hi team, I need to aggregate of a line item-1 with number of accounts and display in another lineitem2 in same module. Line Item 1 - Total Sales Revenue by Account (Each product family has number of accounts under it) LineItem 2 Total Revenue by Country = SUM of account sales target of all the accounts coming under that…
-
How to use “SUM” function in Anaplan: Explanation Through an Example
Hello Anaplan Community, During my Level-I and Level-II trainings I thought that it would be useful if an explanation with an detailed simulation for use of LOOKUP and SUM functions. There for I prepared a detailed explanation for each functions. Below you can find the explanation with an detailed simulation for use of SUM…
-
Level 1 Activity 9.2.3 Revenue decimals ?
While double checking some of my summary and formulas, I noticed that in Rev03 Margin Calculations I have decimals in my totals. However, in the verification screenshot there are no decimals. I checked the formula for Revenue and it is set to Number>with No-decimals. I checked the formula for the References in the line…
-
How to find GCD of 3 numbers?
Hello Community, I have a condition, where I have to calculate the "Greatest Common Divisor(GCD/GCF)" of three numbers in Anaplan so that I can utilize that GCD value to find the ratio. In excel we have GCD function and directly we obtain the GCD value. So, is there any way we can do that in Anaplan. Thanks Puneeth HP
-
Convert a number to Date
Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?
-
Need some help trouble shooting calculations?
Need some help in trouble shooting calculations? How can I get this formula to work? Where do I start? Our amazing Operational Excellence Group (OEG) team share their techniques and best practices for working out calculations and getting them working!…
-
Data type mismatch: format other than LIST or DATE being referenced as a relation Error
Hello, I'm trying to this formula for the bonus line item and I'm getting an error message. IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 Can I have some help on what is wrong? Thank you! .
-
I'd like to pull the value of a line item based off of the selection of another line item..
I'd like to pull the value of a line item based off of the selection of another line item in the same module. I have a LiSS Module called Category Planning. It has values in 3 line items. Depending on what is chosen in the Select Option Line item, I want to pull the respective value into another module. Category Select:…
-
REP02 values not displaying
I currently have a filter to show forecast months only
-
Model 1 Exercise 9.2.5
Hello All...I input 5% on my F19 for REV 04 , then i receive 20% for my REV 05...what am I doing wrong?
-
NaN
Hello, I believe I am running into an issue where some formulas are using the Divide logic and running into NaN when dividing by 0. Does anyone have any reccommendations when converting NaN to 0? The formulas I have logic which says: If Numerator= 0 then 0 else if Denominator =0 then 0 else numerator/denominator. However,…
-
IF NaN Formula
Hello, I am running into issues with the "NaN" when running financial or misc. functions. This causes issues when attempting to aggregate to a parent level. My current solution is: IF ISBLANK(TEXT(***function***) THEN 0 ELSE ***function*** Would be great if there was an "IFNaN" function to allow for cleaner/ quicker…
-
Bring in Data formatted data from one module to another where Target does not have Time dimension
Hello Gurus, I have this scenario. Module 1 has the following: Time dimension (Month) List A Line Items including a line item called ExpiryDate that is date formatted. Module 2 has the following dimension (does not have time dimension). List B Line items (some line items plus one called Date where i need to bring in…
-
Order List Action for End user
Hello, do you consider enhancing the Order List Action functionality by making it accessible for the non-admin users? It would be really great the end user to be able to apply such an order whenever he consider it useful. Thank you Best regards Kristina
-
Use "Previous" with non-timescale dimension
Hi all, I understand Previous() can't be used with a non-time dimension. I have a custom dimension with a natural concept of a previous item. (it's actually a 13 period calendar that is not based on weeks, therefore I think precluding the use of a native time dimension). I understand why it's comlaining; OpeningBalance…
-
Circular reference for confirmed purchase order receipt
I am getting an error in my Sprint 3 activity 3.3.5.1 Create Inventory Ordering Module.when i am writing the formula for confirmed Purchased order receipt i am getting circular reference. my formula = IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0 can anyone help me please!
-
Error Message with Formula
Update the formulas to reference the driver data in the EMP03 Employee Driver by Role module. Formula I am using: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0 Error message after using the formula: IF…
-
Active employee calculation
Hi Anaplan community, I am facing a problem and need help. I created a line item (Active?) to define whether the employee is active or not. The formula that I used is: IF PERIOD('DAT04 Employee Data'.Leave Date) < ITEM(Time) THEN FALSE ELSE IF PERIOD('DAT04 Employee Data'.Start Date) <= ITEM(Time) THEN TRUE ELSE FALSE I…
-
MB Level 1 Lesson 11.3.4 Getting the Wrong Output
I am having an issue where only 1 cell does not match how my model is supposed to look like. It seems like "Utilities" (and subsequent line items that use utilities as part of its formula) is the only line item that is generating incorrect data. The first picture is of MY module, the second picture is what the module is…
-
Rank sequential numbering and skipping certain criteria
Hello! I am looking to create sequential numbering on employee numbered list within their respective cost centers but also looking to skip certain criteria such as TBHs. I am currently using RANK(1, ASCENDING, SEQUENTIAL, TRUE, LIST) which works well for numbering within the cost center but includes all members of the…
-
Extracting parts from a series of underscores like 448_2021_2_2021_3_1_56
Hello All, I am having trouble extracting certain parts from the code like 217_2021_2_2021_3_1_56, that first three digits is the phase code, then year, then month, then another year, another month, version, and location code. Month and version numbers could be one or two digits depending on the date, so not sure about the…
-
Filter data on criteria that can change month to month
I'm fairly new to Anaplan and I'm sure if I'm approaching this issue correctly so I thought I'd ask here. We have sales rep data that shows what "compensation group" they belong to for a specific month, along with what they sold and earned in that month. I'm trying to create a FYTD report on this that shows each…
-
Question on Calculating the Redistribution Factor
Hi, I would like to know if the way I'm calculating the distribution factor is correct? The only problem I believe would be the denominator, because I only want the product values and not the product values total. Any advise would help. Thank you
-
Find Highest value
How to find the highest value for the regions amongst the 3 months and show that highest value in module Test Case 2?
-
LI PY Country and Product Family Sales
Hi, I have been stuck on this problem for quit sometime now. I know my formula is correct and my dimensions of mapping between my modules are correct, so I do not understand why I'm still getting a dim error when conducting the following formula below. Please assist. Formula: 'DAT02 PY Revenue to CY'.PY Revenue to…
-
TAR01 Level 3 Model Building
Hi, Would like to know if my DAT02 Formula and Dim are correct. I'm not able to LOOKUP or SUM in Country and P1 Product Family into my TAR01 Module and it is saying because Dimensionality. Below is a screen shot. dim is A2 Account>Product Thank you
-
Calculation Error for Formula
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 2 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Level 1 Model Building Activity 5/6. Super Stuck - Need Help
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 1.5 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Level 3 Model Build TAR01 Module/SYS03 Module
Hi, I'm having trouble with putting together the TAR01 Module. I understand the task is to get the Total Revenues of my Products (P1 List) by Country and it's "Children" (G2 List), and then fine the percentage of that by dividing by total annual revenue of a country (Total Annual Revenue by Country and Product / Total…