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 th…
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 vie…
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
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
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 ini…
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 mo…
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.
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 previo…
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 p…
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 fo…
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-o…
Hi, I have a number of lists e.g. product list or employees list, but how is it best to maintain these as the list keeps growing, but we have products which are no longer active or employees who have …
Hi, I created a module with exchange rates data for each month. Then, I put summary as : sum, time: closing balance. But as I only have data until Sep 2020, it puts 0 for FY20 and 21. So, I would like…
Hi, would like to ask on how can show the escalation yearly amount? for example FY21, the amount is 10M and for FY22 the amount should be 10M x 1.1 = 11M. Please see screenshots below. Thank you anapl…
Hi, So I'm playing around with trying to build a Cash Flow Model in Anaplan that is on a Daily Time Scale [WeekDay Function I plan to use] and has Line Items of different Accounts in the company that …
Hi, Is it possible to create a combination chart in the NUX which combines all 3 charts in 1? I tried earlier and I was not able to align the dots across each bar chart? They were all clustered togeth…
Dear Community, My budget model's calendar type is Month/Quarter/Years but I need to do some calculations by bi-weekly pay periods and then roll up the result (using SUM) to month. Our payroll calenda…
Hi, Is it possible to adjust the size of a text field? I can hover and see further comments but is there a way to show more than 1 line by adjusting rows? Thanks
Hi, I have created a filter to my module where users can select an item from the filter, which the module will then show those which apply (via boolean). However, I cannot seem to show all items? I cr…
Hello all We are refining the functionality for Bulk Copy as an action. We could do with some clarity over how you see this being used, specifically with regard to ALM. Just a couple of initial points…