-
How to get a first value of line item
Hi, I have requirement where I need to identify the first value of Borrowing line item and that value would flow into initial commitment. So I have used ISFIRSTOCCURENCE with a logic IF Borrowing <> 0 THEN ISFIRSTOCCURRENCE(Borrowing, Revolver Facility) ELSE FALSE but this will giving me two occurrence. what I need is the…
-
I want to get the first month of a period set in module calender.
hi! I want to automatically display the first month of a calendar set in a module that has not been applied to. Can ido it? Please help!
-
Actual vs Plan Reporting Issue (Different grains = double-counts)
Hi All, I have the following 3 Modules: Module 1 - Staging (Actuals) Lists - Supplier, Service Category, Time, Line Items (Amount) Module 2 - Input Plan Data Lists - Supplier, Service Category, Maintenance Category, Time, Line Items (Amount), Versions Module 3 - Reporting Module Lists - Supplier, Service Category,…
-
Why unable to pull the app?
Hi Community, can anyone help to understand the reason behind this error? Post login received the below error (tried more than once).. Is this app no more valid? If so then is there any substitute of this app in hub?
-
Dimensions: Time (Year)
How to change the Time to years
-
Registration for April Elevate Program?
Hi y'all, Does anyone know when the registration for the April Anaplan Elevate program will open? I want to make sure I don't accidentally miss it. Regards, Joshua
-
Disaggregation
Hi Community We are disaggregating data from L1 to L2 based on the past data. As a part of it we are getting decimal data in the L2s. We tried Round Off, But It is not matching the data of L1, due to round off. Is there any way to get the data in whole numbers, without losing the data. Thanks Badam
-
How to get previous value of line item which doesn't have time dimension
Hi, I have a use case where I'm using the custom time dimension list in which there is a line item called Beginning balance which is the previous value of the Ending Balance. So I'm stuck as there is not native time dimension being used in the module so I can't use previous function of Anaplan. Any work around is possible?…
-
Total Count for number of items based on parent and type
Hi I am having an accounts lists (A1,A2...A5,B1,B2...B5) with Parent(Accounts) as A,B and parent(parent(Accounts)) as X. Type of accounts are Type A, Type B. If user(A,B,X) selects an account then the number of accounts under the particular user with same type should be display in target. For example, if User A selects an…
-
Survey Invitation: BPM Pulse Research
From time to time, and as you well know, the analyst community will approach us for customer insights to inform industry-specific research. Today, we'd like to point you, our trusted power users, to the 2022 BPM Pulse survey. Your input will help to influence BPM Partners' annual Vendor Landscape Matrix for business…
-
Propose to add Formula AutoComplete function
It would be great if Anaplan can have the Formula AutoComplete function just like what the Excel formula bar, so that user doesn't need to memorize all the formulas and general lists.
-
Avoiding a large intermediary module
I have a list of transaction codes that a user wants to summarize in a report that replicates what they've produced in excel. The transaction codes don't form a natural hierarchy for this. The excel report pulls out various individual codes, groups some together, summarises others etc. To achieve this I've got a line item…
-
How to get first date of the model
Hi, Does anyone knows how to get the first date of the model? *The first date that comes from the time dimension I want to compare the first date of the model against date input by user.
-
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.