-
Google Chrome Extension to make long formulas easier to read
Hi everyone, I created the chrome extension Anaplan Formulator to make long formulas easier to read in the native formula editor. The extension inserts a return before and after each IF, THEN, and ELSE in the formula. Please take a look and let me know what you think! Thanks, Ryan
-
Synchronize to Specific Level of Hierarchy
Ability to select a level of the hierarchy to show and have synchronization based on selection. Ability to have separate tables built out for a hierarchy to drill down into without creating separate modules. If we could select the level to show in addition to having synchronization based on selection it would eliminate a…
-
NPV Formula with time adjust.
Hi, I need to replicate this formula from excel: =VNA(wacc;cash flow)*(1+wacc)^0,5 Could you please help me? Thanks Nacho
-
Aggregation function for non-list data type
Currently the aggregation functions only work towards list data type. This disallows to fully replace VLOOKUP function in Excel. Please add at least some additional functionality: for example to search for FIRSTNONBLANK using text data type. That would allow to more easily deal with data without need to maintain excessive…
-
More options for TEXTLIST
There is currently no way I can use TEXTLIST function with both unique values AND mapping. * Either you can use parenthesis function with UNIQUE property * Or aggregation function with mapping but with entries repeating. To sum up both use cases are incomplete. Please add option to turn on both features at the same time: *…
-
Simple check on Data
Hi, I think this should be an easy solution, and maybe i am trying too hard Consider the module below, data coming from a list start date, end date, and a count (1 = yes, 0 = no) I want to populate Previous YN with a 1 IF the promo count was 1 for the previous period. So in the example above #2: 31/01/2018 to 28/02/2018…
-
Ability to use Concatenate (&) in a Select Function
I would like the ability to add an Concatenate to Select Function. For example SELECT: VERSIONS."Budget "&NAME(Current Year). As we have multiple Budget Version, the current version in play and the future version. So in our variance reporting module it would select the correct version as budget. Similar with forecast ……
-
Formula Help - Check on only entry
Hi everyone I need some help with a formula. I want to create a line item (LINE ITEM B) to check that another line item (LINE ITEM A) only has an entry in one period. The line item that I want to do the check on is a manual input and has a numeric format. I basically want the model to flag an error to tell me if there are…
-
Formula
Hi Experts, I am using two line items, Both line items are text format. Line item 1: FCST_1 Line item 2: FCST_2 For suppose FCST_1= 5.4591 Then By using FCST_1 we need to calculate FCST_2= 5,46(Rounded value AND instaed of dot we need replace comma) To do the requirement i write the below formula FCST 2= IF FCST_1 = 0 THEN…
-
Running balance of a numbered list
Is it possible to get the running balance of a numbered list? my numbered list is a daily cash transactio and i need a line item taht will get the running balance per transaction. Thanks!
-
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?
-
Hide List Property Columns when view is on Dashboards such as the 'Parent' or 'Code' or propety
Hi Anaplan, It would be really helpful if it were possible to hide the 'Parent' 'Code' or any property columns on list views published on dashboards. This is to prevent any destructive inputs such as changing the hierarchy by accident. Thanks, Usman
-
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…
-
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
-
How to do use dropdown list within the PROFILE function
Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a drop-down list from a number of different allocation profiles to use in the PROFILE function. To hold the different…
-
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…
-
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…
-
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 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:
-
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
-
Formula for the Hierarchy
Formula for the Hierarchy
-
Poisson function
My customer needs to calculate the POISSON cumulative results to find out the lambda value that goes above a probability treshold. In a maintenance use case, this is useful for him to statistically determine given a target service level and the past average of incidents how many incidents should occur in the future, and…