-
Incremental Load
how to do incremental load for transactional data?
-
NaN formula
Hi, Please see attachment for my inquiry. Appreciate the help on this. Regards,
-
Read Only for submit once approved
Hi, I have 2 line item, Submit and Approved, Both are Boolean format. Once an Item is both checked for Submit and Approved as True, I need Submit(line Item) to be read only, i.e it should not be allowed to unchecked again. Thanks & Regards, Asha
-
Issue with Formula
Hi Experts, I have 2 issues with my formula, 1. I have written a formula to line item "Territory Code as Number" = IF Active Assignment? AND LEFT(Territory Code, 1) = "G" THEN VALUE(RIGHT(Territory Code, 2)) ELSE VALUE(Territory Code). I have considered the below things to the line item. Format = Number Time Scale = Not…
-
How to find the mid point of a mid point between 2 dates
I have start and end date for an event. I would like to find what the mid point time period between these dates is. Is there a formula I can use to do that?
-
How to import to a numbered list from a numbered list in a different model?
How do you import to a numbered list from a numbered list in a different model - using the 'connect to Anaplan model' function? The aim of this is to store the lowest level of my organisation's hierarchy as a numbered list - this is needed as some of the organisation unit names are duplicates. At the moment, I get the…
-
Disabling boolean check for only particular member in a list
Hi, I have a flat hierarchy, which is used in a module. A Boolean line item is created in same module, but I want my Boolean field to be enabled only for particular member in the dimension list and disabled for all other members. Regards, Madhu
-
1:1 relationship for sales title and plan ID will now be 1:many
Hi, We have a list called Sales Titles which has all of our Sales Titles. The code for each sales title is a plan ID. 1:1 relationship. Some sales titles have the same exact plan components, but just different plan IDs. We have a request that now they are reducing the number of plan IDs as some sales titles have the same…
-
What are the best practices to understand a model?
HI, From a model builder point of view, what are the best practices to follow in order to understand an Anaplan model built already when there is no documentation available (no design docs) nor technical knowledge transfer? Thank you in advance!
-
How to add prior year data value
Hi, I have a line item Headcount and my current year is FY17. For FY18 I need headcount value to be prior year headcount and FY19 to be FY18+FY17 headcount value. Can I please get some guidance. Regards Madhu
-
History not getting captured for Cell
Hi, I have entered 128 value in one of the cell in module. However,after few days i could see value has been changed to 125. Upon checking in the history,last value change is showing as 128 and nowhere 125 value change has been captured in history. Please help on this.
-
Totals at rolled up level
Hi, We have applied some filters on the basis of which we want the data to be published on the dashboards. The data is correctly being picked up as stated in the filters, however at the total level(level at which data is getting rolled up) the totals are coming incorrect , it picks totals of the entire e.g. region/category…
-
How to take summary values into calculations?
Hi i'm trying to get last fiscal year actual values but not able to take it to next year budgeting please help.Below i'm putting the logic & where i'm struggling. Time apr-18 may-18 aug18.......FY18-19 Apr-19 may-19 jun-19 jul-19 Fy19-20 Actual 1000 2000 1000 4000 Budget 4000/12 4000/12 4000/12 4000/12 Here i'm not able to…
-
102 Certification Project - Corporate Profit
Hello, New to the community and stuck on Company Profit as none of my output match for answers in the certification quiz. My COGS doesn't feel right so I attached my Partner and Direct revenue Blue Prints as well. Not sure how to proceed as I've racked my brain on this. Thanks
-
How to Convert Number into Weekly format?
Hey Anaplanners, Is there any way that a particular number or text can be converted into Weekly format? For example P1 2018 needs to be converted into Week 1 2018 in a Time Period Formatted Line item. I know for the fact that we can create Date from number but there is nothing as such for Time periods esp weeks. Let me…
-
If Formula Error Message
I need help with a formula. In a module to calculate 401K match for employees, I have the below. There are 2 types of TM's - "Regular" and "PRN". The below works perfectly for "Regular" TM's. However, I want to add an IF statement to the TM Total Salary calculation that basically says IF TM Type = 'Regular' THEN use…
-
Can we create alias names in anaplan?
Can we create alias name for time,versions dimensions in Anaplan?
-
How to Count Text Value based on the Input.
Hi All, I'm fairly new to Anaplan. I want to count a list item (Model State in Text format) to be able to output its count to my dashboard. The three current inputs are Maintenance, Production, and Unlocked. I want to be able to show on my dashboard how many models are per state. I tried fiddling with the IF function for…
-
Anaplan and SAP BO to Tableau connection
we are using Anaplan to view my data in tables. Is it possible to get the data from Anaplan dashboards and visualize them in Tableau? Same applies for SAP BO reports. Thanks in advance Saanvi S
-
How to: Annual Repeating Value shown with Monthly phasing (rents etc)
I needed to take an Annual contract value, and model the payments by month at different frequencies and came up with a solution I thought others might find useful. Here's the finished dashboard. For each Site, you select a Payment Schedule. Input the Annual Contract Value and tick which months to allocate the payment to.…
-
How to add cell values for previous 8 months data only
I have an line item 'Amount' with data values. second line item(months applicable) which is boolean checked for only 8 previous month of current month. I want to add the values of these Boolean checked months only to be summed. Can I please get some guidance here please? Regards Asha
-
ABS formula
Hi, anyone who can help on formula "ABS"? I need to get the absolute value of the line item, but Anaplan seems to round off the item. Any notes on this? Thank you. Below is the screenshot for sample:
-
Process builder in anaplan
Hi, Can anyone give brief about Process builder and its task in anaplan. Thanks, Keerthi Malathkar
-
How to get the previous period of current period
Hi, Can I please get some reference how to get previous period of current period. PERIOD(CURRENTPERIODSTART()) gives me the current period I,e Jul 17 but I need Jun 17. Previous(period(currentperiodstart()) which is not working.
-
How to add cell values for previous 8 months data only
I have an line item 'Amount' with data values. second line item(months applicable) which is boolean checked for only 8 previous month of current month. I want to add the values of these Boolean checked months only to be summed. Can I please get some guidance here please? Regards Asha
-
Can we create alias names in anaplan?
Can we create alias name for time,versions dimensions in Anaplan?
-
Hierarchy change in planning years
How to save the data of the previous years when we want to change the list items hierarchy in planning years? Other than creating a copy of the model, is there any solution??
-
Formula for the Hierarchy
Formula for the Hierarchy
-
Sorting Users in Anaplan
Hi Guys Does anyone know a way to sort users in anaplan . I am talking about the User setup / Access Area . I don't want to delete users and re-add sorted lists as it will generate email notifications to users . Cheers
-
Referencing Model Calendar in Formula
Hi all, I am trying to see if there is a way to reference the model calendar in a formula. I want to return the fiscal year that the week is in. e.g Week 1 FY19 Result would be FY19 The intention is to use this to lookup other data, E.g IF Fiscal year = FYxx then... I have a Timing - Calendar Module (screenshot below) if…