When I am trying to enter the formula in REP02 Size Margin Report revenue i am getting an error like this ... (Data type mismatch: format other than LIST or DATE being referenced as a relation)
Hi all! In our model we do not get the wished results from a moving sum. I want to preform a movingsum over a line item which is constructed with an if statement in a model with versions. This is my l…
Hi I want to Textlist function. I want to get Customers by Product List. But I don't know how to use it. ListLineitemProductCustomerConbinationTextListP1C1☑C1,C2 C2☑C1,C2 C3 P2C1☑C1,C3 C2 C3☑ Do you h…
When we all had classic dashboards only, it was easy to check which module is used in which dashboard by going to the "Used in dashboard" column. However, as most of us are using new UX now, the colum…
Hi, In response to question 7: What was the total expense for the FY21 executive bonuses in the Americas? the total equals XX.999999999996 do I have to round up? Thank you
Hello Could you help me with the following case please. I have a formula that is using SELECT but in addition to that I need to add a sum controlled by months with some members that I have already cre…
As you consider the areas in need of a spring refresh in your home or office, it is also a great time to do the same for your Anaplan models. The most difficult part about cleaning is figuring out whe…
Dear Community, Needed to check whether is it possible to delete Monthly data using Delete from List using selection for that particular current month. For example if we have data from Jan 2022 to Apr…
Currently option for an inputable cell when right click are copy, hide, breakback, sort etc. It would be nice to have the option of Copy Across and Down in dashboards. It is already available on the e…
I'd like to have new features in Anaplan where it will check your whole model and return the following: * Module/Lists which are not references in actions/dashboards and therefore can be removed witho…
Similar to Cell or Module history, there should be an option to get on demand history on formula changes. An option in blueprint mode to select any line item formula and get history option should be a…
Currently the model history process only captures that a line item was edited but it doesn't specify if it was a formula change, applies to, etc... and it doesn't include what the formula is/was. This…
When model building often we get requirements that require changing the dimensions of a line item / changing hierarchy levels etc. Basically things that will break existing formulas. To make these cha…
Hi Anaplanners, This time i am coming with an idea of having a kind of manageable clipboard/notepad built into the development UI. Performing development work i usually have some additional tools like…
Hi, I have a requirement to pull the dates in the module, the source and the target has different dimensions. Target module Source module I want the dates basis on the revolver in the target since I c…
Hi everyone, Currently have a developed user-selected time filter we use on all of our UX Pages. Driving module: Page/Board Filter: We just implemented the YTD summary yesterday and now I am strugglin…
Hi, Can you help me with the next item. I need get the total value of the line item "%" and put in the line item "Pond". in the line item "Pond" is using a LOOKUP but a cant see any value.
Hi , I want just calculate the moving average for the last two months, however once use the following formula IF ISACTUALVERSION() THEN Revenue actual ELSE movingsum(Average Revenue,-2,0, AVERAGE) The…
Hi team, There are four lists L1,L2,L3 and L4 in which L1 is parent of L2, L2 is parent of L3 and L3 is parent of L4. I have a requirement in which I want to mark true all the descendent members if I …
I would like to see shorter time periods that we could control for example rolling 90 days, 16 weeks etc. Realizing there would need to be some sort of trigger of control set a start point. A potentia…
Hello, I know this is an example, however I am unable to get these numbers Account Review Module For Small Segment my numbers are: $10,716,645, is anyone having the similar issue? any guidance will be…
Hi - Super stuck on Activity 2.3.9 and 2.3.9.1 for the past 3 days. Any help would be much appreciated. Question 1 - for 2.3.9, what am I supposed to do here? The directions or lack thereeof are super…
Hi Team I am having an hierarchal list (Product L1,L2,L3,L4,L5). I am having a module which is having Product L5 list as dimension. I have published the above module to the dashboard and also publishe…
Hi guys, As you see in capture 1 we have the Role wise salary details , but i a not able to get these salaries by employee wise , please look capture 3 sys module is there anything i am missing to get…
Hello Community, anybody to help me, I'm trying to pull data from Module which has Time,Version,Lis as List and Amount as line item in Target module which does not have time and version means it has (…
Hi there, While creating the saved view for the line chart for my DEM03 Demand Forecast module i noticed that I only have 1 year of data for FY20. The requirement is asking for a view with 2 years of …
Hi, I have trying to complete the Medical costs for 2 days now and I can figure it out. I created the list of roles: Created EMP003 Employees-imported employees by roles data Added Roles to SYS08 then…
