-
How to omit time ranges from Applies To
Hi. We have a table has applies to(Region, Time). The table has line item "temparature", We added line item Time=item(time). When we export the table from anaplan, We want omit Applies to not only region but also Time. How can I omit it.
-
Question on Time setting Module
Hi, Trying to create a Line Item "Week # of the Month" that will give me from 1-4 the week number of each month when referencing my "Reference Date" ex) with Reference Date "2 Jan 19" the outcome will be Week 1 or in formula &"Week"&.... any help on this will do. Thank you
-
Time Setting Module
Hi, I want the Line Item "Current Week # of the Month" to show Current week number of the month when Line Item "Reference Date" is selected. Thank you
-
Setting up SYS Modules for Time Settings
Hi, What function would you use to display the numbered week in the Month, ex) the third week of the Month.
-
Formula - Previous?
Hi, I have a module that shows the full-year forecast amount for various expense categories. It also compares the current forecast (2021) to the prior forecast using the formula PREVIOUS(Full year forecast). That was fine in 2020, but now we are in 2021, the prior forecast shows nil. How can I fix this so it picks up the…
-
Rounding not correct in ALL
Hi, Do you know why I'm getting wrong value on Total Containers for ALL for Inbound Pallets (see image)? For example: W/c 18th Jan 21 should be 4 and not 3. I suppose the 3 is based on 1.159 + 1.159 = 2.318 so rounds to 3. But I want it to be based on the already rounded 2 value. I can't use SUM in the Total Containers…
-
How to search Sort option?
Hello. The new Action "Order List" is added. So I tried to change "old sort option" to "Order List Action". The Refurbishment step is below. Step 1 : Search all modules which are sorted by Line item. Step 2 : Change to Order List Action. But when I do Step 1, Another Sorted Information has appeared like this. I think this…
-
Treatment of duplicated identifiers in target
How Treatment of duplicated identifiers in target works? I set it up "Reject entire import" But I see that List is getting updated? Can you please provide an example? @Misbah
-
How to identify the Top Level item in a Module
Dear All, I have a requirement to show elements belonging the Top Level item in my Module, but unfortunately i cannot identify the Top Level Item, since i am unable to capture any of the properties (or) Attributes of Top Level item. Top Level item is defined in Level 1 Level 1 is parent of Level 2 Level 2 is parent of…
-
Sum Error - Mismatch
Hi, I am attempting to bring in the sum of one line item from one module to the next and getting the error: Data type mismatch: format other than LIST or DATE being referenced as a relation Here is the formula that is failing: and the referenced module: Thanks!
-
Versions Question
Hi, I'm trying to set up my Model so that I can View the Actuals for the actual day it is and then after that just forecasted numbers. My Model is set up in Days of the Week and want to be able to view actuals for that certain day and then Forecasted numbers after that. Do I use the Switch Over function? and How? Thank you
-
weekday function
Hi, After using my weekday function, I got the number to display. Now how do I get The actual day of the week to display verses the number of the day of the week? Thank you
-
Setting up a Time Setting in Model
Hi, I would like to know how I would set up the Time Settings in my module so that I'm able to see the actuals for the day Selected, and then Forecast Numbers only after that day? Thank you
-
Applying a TRUE boolean across all months when a single month is TRUE
Hello, I have a module with three relevant dimensions: Position ID (FLAT Position ID) Component (FLAT Components) Time (monthly) For a component under a position, if any month is marked true in an initial line item, every month should be marked true in an associated line item. Screenshot attached, but in the example if TBR…
-
Calculation with different dimensions
Hi, I have 2 modules : one with the headcount and the other one with average salaries. I want to create a third module with total salaries (which is headcount*average salary). But, in the headcount module I have the headcount with line items internal vs external, and for salaries I have salary as line item. How can I…
-
isfirtstoccurrence formula
Hi, question please. I need to get the first data(#1), hence I used the isfirstoccurrence but not sure on why the #2,#133 and #362 are also checked in the boolean? Thank you.
-
summing up prior year data
Hi, Question please. I am trying to sum up all the values in the Depreciation line item column for prior years 2020 in my calc module by company. However, I'm having a difficulty to get all the previous years data and sum it up. Thank you.
-
Uploading into Anaplan - YTD
Hi, I have a module where I'm uploading YTD actuals into Anaplan. Does Anaplan know it's YTD actuals, rather than values for that month? How do I tell Anaplan to take the last upload, and ignore the previous ones? Thanks
-
Subset not populated from module boolean import
Hi, I have a numbered list of Employees that I've created 2 subsets for: Hiring Manager Approval Manager So I created a module with the list as dimension and then boolean line items used to fill in for hiring and approving managers, and then import those module line items to the list to populate the subsets. For some…
-
New article: Decreasing Formula length
All, Just wanted to point you to a new article on using line item subsets to decrease your formula length. You can find it here: https://community.anaplan.com/t5/Best-Practices/Decreasing-the-Length-of-Your-Formulas/ta-p/88467 Please let me know if you have any questions, Rob