-
Performace of using LOOKUP and SUM in the same formula
I've heard many times not to use LOOKUP and SUM in the same formula because it negatively impacts performace. However, I'm looking at the "calculation effort" cell and it doesn't appear to be negatively impacting performance much at all. I have the option of using some if statements instead of the SUM formula in my…
-
Count Unique Items Function
Hi, I have 2 lists, 1 is products and 2 is numbering - see screenshot. I have a module where it is dimensioned by product and the numbering and I want to count the number of unique values. Based on my screenshot, it should be 15. I saw there was a formula - isfirstoccurrence, but I'm not completely sure how to use this.…
-
Loading Data at Parent and Child Level but avoiding double counting
Hi Community, I am stumped on how best to handle this situation. I have to ingest data at multiple levels of a list hierarchy. i.e. Parent Level (fruit) and child level (eg. apples) but I need to avoid double counting when reporting? I am struggling with how best to handle the situation without double counting or excessive…
-
Propagate data from branches/parent lists to leaf lists
This one is not for the faint hearted lol. Functionality is to have ability to capture business policies at different levels of the hierarchy. Business policies have customer and product as dimensions. The customer/product list levels is configurable. Customer list has the following hierarchy: Country ⇒ Channel ⇒ Customer…
-
Common Reasons you cant add a dimension?
Hi all, I have a very complex model. It won't let me add a Product dimension to it. The processing time is so long (25 min) that it just times out and never gives me a reason. I was wondering, what are common reasons you can't add a dimension to a module? thanks in advance
-
Reverse BOM recommendation based on Attributes
Hi, Consider this scenario for a Diamond Industry supply chain Demand for Diamond from customer comes with various attributes [cut, carat, clarity, etc etc] Prospect has made over the years diamonds with various attributes. This historical data is available [both BOM and Recipe]. There is a unique Stage 1 BOM and Stage 1…
-
Level 3 - DAT02 PY Revenue to CY
Hello all experienced MB's Created a Module to Pull PY revenue to CY, Module has dimensions A2 Account>Product# and G2 Country. Whatever country I select the value shown is for ALL regions This is something to do with aggregations, but I'm struggling to figure out which is correct, surely SUM is incorrect. Any suggestions?…
-
resetting filters
What is the cleanest way of resetting filters on in a page in Anaplan? Is there a way of defaulting the filters to show the total level? Thanks.
-
How can I understand which columns are needed in an upload file?
I am looking at uploading a flat file and getting the error of "property-based import has one of they key properties unmapped - cannot proceed". So I was thinking, how can I understand exactly what the headers should be in an excel for flat file? is there a way of finding this in modules? e.g the columns should be…
-
List Help
Hi, I have a list of bank loans. In this list, there are some bank loans which are no longer current, but my total of all bank loans includes this in the total. As there will be new loans, loans repaid throughout the period, what is the best way so I can see a subtotal of only current loans? Thanks,
-
Numbered list
After Importing into a numbered list, the list contains Number, how to show the Name instead.
-
History Pull Inconsistent Record
I pulled the history log for a specific time period and filtered it by module, line item, and list items. I'm trying to understand how to interpret this history: Row 1: Previous value was 0.5 → changed to 1 Row 2: Previous value was 1 → changed to 3 Row 3: Previous value was 0.5 → changed to 3 Row 4: Previous value was 3 →…
-
Lookup error : invalid lookup list X is unused
Hi guys, I am facing an error for the first time and I was wondering if anyone had an idea on how to get throught it For some context I have : LI1 reference dimensionned by "Dimension A" format number LI2 target dimensionned by "Dimension B" format number LI3 dimensionned by "Dimension A" format "dimension B" (a basic…
-
Level 2 Sprint 3.3.5.2 Confirm Purchase Order Receipt Line Item
Hi everyone, would really appreciate if anyone could help me with this problem. My formula is 'IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0'. Is this formula not correct? I have been trying several different formulas using my logic but cannot seem to get it right.…
-
Context Selector filtering on UX page
Hi All, I am stuck with a request where I need to filter a list based on a Boolean condition. The Boolean condition is working all fine but when I publish and apply over the app page, there is a version selector which is causing the issue. Its asking me to choose a specific version for the Boolean to work, but I want it to…
-
Multiple Lookups into DATA... module?
I have 3 hierarchies, Customer (C1-C9), Developer (D1-D3) and Product (P1-P6). I also have a combined list C10 which is C9_D3_P6. I have a DATA Rebates module with a LOAD list dimension and properties for C6, D2, P3. I have a reporting module with C10. I've also got a PROP C10 module with line items for each of the items…
-
How to add coulmn to show % from overall total??
I want to add another coloumn to show percentage for example level 2 % will be equal to 34/total no of inc and so on? how to do that
-
How to add totals for L2,L3 and L4 to show total of levels values for all categories???
How to add totals for L2,L3 and L4 to show total of levels values for all categories???
-
Can't Import a CSV File - "Cannot read properties of undefined"
Does anyone have experience with this error? I'm trying to load into a module and this message comes up as soon as I select a file. This happens even when trying to load a file we used last quarter which had no issues.
-
Bring info from another module
Hi everyone, i´m having some issues here trying to bring information from a module with different dimensions. Data should flow from a line item called Style function plan to the target, any suggestion here? Here are the dimensions: Source: P4 Department (rolls up to p4), Checkpoint meetings, Combined Climate, Sub C3: LY,…