-
how to pull values from one module to another module with no common dimension?
I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
-
What are Blank Lookups ?
How can we use in Anaplan and Give me a scenario where can i use this Blank Lookup in Anaplan
-
How to calculate Run rate
Hi All What is the best way to calculate a 12 month run-rate formula in Anaplan. Below is the calculation I used but am not getting the right figure. Also 0 used MOVIMSUM(Actuals, -12, -1, AVERAGE) but not getting the right figure Your input will be really helpful. Thanks. In this calculation module I referenced the…
-
Delete rate button
Can someone help me out on adding a "delete rate" button on the UX side? Thanks in advance.
-
source with more dimension than target
l Line items: source-target ok period: source-target ok sales group: source-target ok product group: source-target ok order type: list exists only in source - OrderTypeTotal -value should be transferred to target delivery channel: list exists only in source - DeliveryChannelTotal -value should be transferred to target…
-
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
-
Need to figure out the formula in anaplan similar to excel
Formula for Final exploration drilling (Dryhole) in excel is - Basically IF the first line items current year value is <>0 then then sum all the previous year and if the sum of all the previous year is zero then bring the data from other module. Question is - How to look up all the previous year?? for example if the year…
-
Sync on Selection - Multiple dimension Cell based
I understand how synchronization on selecting a list on grid works, I am trying to see if I can make it work on multiple dimension. eg, if I have a grid with list on my row as well as column. Is it possible to select a intersection cell and be able to synchronize select both list? Any tricks for that.
-
SUM Formula Error
Hi All, (a) I have an input module dimensioned by CC & Categories & Version & Time (Quarterly) (b) I have 2nd module dimensioned by CC & GL & Version & Time (Quarterly) © I have the summary module Dimensioned by Categories & Version & Time (Monthly) (d) I have a mapping module of CC & Categories FINAL RESULT (Categories)…
-
Model Sparsity - Combination of Dimensions
I have a question about reducing sparsity in a model by using numbered lists to combine a series of dimensions. I am using ledger data that has information by supplier and by department over time. If I create a module that is dimensioned by these I end up with a huge amount of sparsity as most suppliers are just used by 1…
-
Cell counts vary for the same formula
Hi All, I downloaded the Line items from a model I've been asked to review. On a number of instances there are duplications (ie the same formula copied in a number of modules). an example is where the same line item formula is copied 3 times over: Instance A - 3.2M cells Instance B - 600k cells Instance C - 4k cells So…
-
Query on Time Range
I am working on a one module where there is a time range added. After changing the financial year I changed the time range from FY23-24 to FY24-25. The cell count has become double after making this change. I checked Time range summery is same for both. Can I get a possible solution for this.
-
Can't create workflow
Hello, I was wondering what kind of license/right I need to create the workflow, since I cannot see the "create" button appear above. Thanks, Luca
-
Data hub vs Data Management System
Hello, I attended part of the last webinar in which the DMS (data management system) has been introduced. I was wondering if anyone could help me understand the difference between the two approaches, in particular on the data source side. I find it hard to understand Many thanks, Luca
-
Combining list format and text format
Hi. I have tried to combine two items but because one is a list format, and the other one is text format I am not sure how to combine the two for a concatenation. Thanks in advance
-
2.3.8 Activity: Volume Growth Rates
I'm encountering difficulties in accurately mapping dates in the format "20-jan" , "20-feb" to the appropriate time periods within my model . Any tips ? Thanks
-
Rate/Balance Variance Analysis
I'm trying to create a standardised way of doing a rate/balance variance analysis between 2 different scenarios (Scenario A and Scenario B) for an output variable to show what is driving the difference. I'd like to be able to select the balance from a drop down and a rate to apply from another drop down and have the…
-
Can we pull data from Source to Target module with different dimensions
Hi, In my source module, i have Employee List and Line Items (Name, Date (Date Format), Salary) In Target module, Have Employee List, Time and Line Items What formula should i write to pull salary numbers from source to target module? Thanks, Priyanka
-
Anaplan native user list or custom user list?
What are some of the considerations one should have when trying to decide between Anaplan native user list and custom user list?
-
Formula or Function to calculate a trend from historical data
I am currently trying to calculate rate of leave taken of prior periods and compare it against corresponding months across different years. I was wondering if someone knows of a function or formula that works best for this? Rate of leave taken = Accrued liability reversals(taking leave)/ Previous month(FINAL Existing hrs)…