-
Level 2 1.3.6.3 Create Build Location Saved View and 1.3.10.4 Check Your Work
Can anyone explain why I'm not getting the view as displayed in the instructions? My screenshots show my saved view, the view after the import, and what it should look like. Thanks!
-
Need to know why getting Circular Reference
Hi, I'm adding my "Inta Month Growth" LI to the formula I have in the "Less:Ineligibles" LI and getting a circular reference. I can not seem to find the root cause of the circular reference. Please advise. Thank you LI "intra Month Growth" Formula LI "Less Ineligibles" Formula The Circular Reference I receive when adding…
-
% Percentage
Hi Team, Wanted to confirm if the below screenshot is correct? In my module, calculations are working but why is it coming as 105% in the screenshot - Check your build Thanks
-
10.2.4 Activity: Import Data into Employee Drivers Module
Hii after mapping successfully, Bonus % showing 0 value
-
How to calculate the YoY growth in line item
I have Year wise numbers in my line item in a module, now i want to calculate the Year by year growth in between years. I want to calculate FY21 YoY = FY21 Productivity growth / Fy20 Productivity Growth. FY21 YoY= 2.55% Please suggest me how get the result.
-
Excel Add-in and Updating the Data Model
Hello, I've built out some Planning worksheets using the Anaplan Add-in and I'm noticing that when a new member is added (for example, a new GL account), the sheet has to be refreshed in order to function. I'm writing to see if this is regular behaviour and that I should expect to always have to refresh and use the latest…
-
Workspace request
Hello, Can you please advise where I can apply for 90 days workspace? There is no button APPLY. Regards, Telman
-
if formula question
Hi I'm trying to make formula but it's not going well IF ステータス = 承認済み THEN TRUE ELSE FALSE how can i make this formula? I need your help... please help me
-
Incoherent summary when period is quarters, year or even YTD
Hello, I'm really at the beginning of the journey of being Model Builder so I'm afraid that what I'm to ask you is really basic, but hope to find help and the learn more :) . The context of the issue is that the following line item is looking for the customers that have 0 revenue in the current month, and if is true, then…
-
How to download model from my anaplan workspace
I would like to download my workspace models, can someone help me out of it
-
Level 3 - User story 1.5 Initial Account Sales Targets
I am trying to achieve the result like this: but once I finished in the anaplan, it looks like this: You can see the total is identical with the training material, but if we check "Candyate", they have some gap. I am sure the target is correct, the issue should come from revenue I guess. I track all my modules, here are…
-
Formula Help
Hi, Need help on creating a formula where it takes a input % for the month, and if a End User wants to change that % then they can and that % will run through the End of the Month. Having trouble making that daily input % run through for the rest of the month. Formula is below
-
Lookup Mapping
Hello Experts , I just Want To Take Data from (Increment by Product family) to (increment By product) For this I used Lookup Function ex Increment by Product family[lookup: Product family] formula apply successfully but did not get any value . can u help me Remember Product is the child of product family Thanks in advance
-
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…
-
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…
-
Accidentally Deleted Users
I accidentally deleted all the users from my workspace. Is there a way I can get to know which all users have been deleted, so that I can restore them back. I have added some users for whom I knew the mail id, but dont have the complete list.
-
Help with 13.11.2
Hi, I am working on 13.11.2. I have everything built out correctly except the combination chart bar graph. I keep playing with the pivot, but I cannot get the chart to go into a bar graph instead of a line graph. Can someone help?
-
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?
-
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:…
-
Custom Version
i have a custom version = actual, plan, forecast Q1, forecast Q2, forecast Q3, forecast Q4. how to use switchover on custom version ?, or if i cant use switchover, how must i do it ?
-
Cannot see line items in Pivot View but available in Blue Print
I have a wierd thing happening with this particular module, where I cannot see the Line Items in Pivot and I'm not able to change the view due to this. But I can add, remove or delete line items from the Blue print view. Is there something to do with any settings or is it a bug?. I've attached images for reference. If some…
-
Level 1 Exam Question 4
Can someone clarify something please (I'm not looking for answers since this is the exam). But portions of exam questions or activities are blank as I'm going through this. For instance, I can see L1 Model Building Activity 4 page, but the following activity page is completely blank. I was able to see a screenshot of that…
-
Is Display Name Property only for for Numbered List?
Hi All, Is Display Name Property only for for Numbered List? Thanks SA
-
What is Difference between NMX and Old module
Hi I have registered for learning L1 Module in NMX and I have seen there is other L1 Module also can anyone help with this what is the difference in that
-
Access
Dear All, Kindly advise how to get an access to workspace (free 90 days)? Kind regards, Telman
-
Numbered List showing numbers alongwith Display Name
Hi All, Can you please advise why it's showing numbers along with Display Name in list? Also not showing numbers for some members.
-
Scenario Planning and snapshot
Currently, we use version for snapshots. For example, create a new version for each submission, bulk copy and lock the version. However, due to size issues, we are looking for options and have heard about multiple scenarios, and snapshots. Wondering if there are are literatures or videos on using scenarios and how to…