-
Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Hi All, After working on the formulae in this section , the expected result is not as shown is section 3.3.5.3. Please find attached the screenshots of the "my output", "expected output" and the "Sys01 time setting". Request you to guide me where am I committing the mistake so that I can proceed. Thank you, Har**bleep**ha.
-
L2S3 Sys00 Time settings by month module Planning Period Filter
To add line item: Planning Period Filter? Saved View Name: Planning Period Filter for UX * Show only the Planning Period Filter line item * Filter to show months only I added this as a line item planning period filter as Boolean and entered true and then deleted it also added a filtered function filter by the line item…
-
Query sales order data into sku properties
I am currently working with a dataset that has all sales order information and have the goal of creating a boolean formula to mark true if a sale on a product has occurred in the last two years. The data module and sku modules are related based on a column with item ID numbers, but I am having trouble pulling the sales…
-
Custom Time Aggregation
Dear Anaplan Experts, Would it be possible to build a custom time aggregation function while still being able to leverage our system time functions? For example, I am doing some salary calculations at the granularity level of day, then I would like to aggregate the period of 2022-05-25 2022-06-24 to June 2022 because our…
-
L1 MB Certification Test: EMP02 Employee Expenses
Hi- I'm trying to update the formulas to reference the drivers in EMP03 Employee Drivers by role. I keep getting an error when i try to update the formula. Do you know why this error is happening?
-
Parent Child addition
Hi , I need a help in calculation of data at lowest hierarchy level giving values to parent level. For example, l0l1L2DataExpectedFunction usedAa1b11133=SUMIF Aa1b12233 Aa2b2111443 Aa2b2222443 Aa2b2110443 Here, I want values added of all the l2 who has same parent. Can anyone suggest me way out? Thanks, Divya
-
SUM results not matching up to summary
I'm having an issue with SUM giving me unexpected results. When I'm working with hierarchy lists and just need a top level sum rather than subtotals at all levels of the hierarchy, sometimes I'll use a 1-item list, add a line item set to this list item, and SUM over it to get the top level sum. It's a little convoluted but…
-
[BUG] Line item format vs value format (YEAR vs MONTH)
Hi Anaplan Devs, I have probably just found an error/bug. Case: 2 line items, one formatted as Period:Month (let's call it LI_A) and second as Period:Year (LI_B) Value in LI_A: Apr 21 (or any other month period) Formula in LI_B: LI_A -1 Expected result: FY21 or FY20 or ERROR (basically if successful then formatted as Year)…
-
Concatenate values
Hi guys, i would like to know if its possible to concatenate values like this to create a code: - i have three line items : Year; Currency; Group - the final output i want for my code is : TypeYearCurrencyGroup i dont want to add a list or create a manual entry for 'Type' because it will always be the same since there is…
-
Avoiding a Circular Reference
Hi, Having a problem avoiding a circular reference when it comes to this Anaplan Formula. The circular refence comes up in the Line Item's "Excess Funding Sweep" when trying to make equal to the "Calculated MCA Sweep to Excess Funding", because the "Calculated MCA Sweep to Excess Funding" references the "Securitization…
-
Quarterly Totals in Months
Community, In my module for forecasting salaries, I want quarterly totals in months (see attached) to be used for Superannuation calc. But I want to achieve it using MOVINGSUM (or similar) based on a "Pay" line item which resets after every 3 months. Any help would be greatly appreciated! Thanks, Shubham P:S: turning on…
-
How to calculate the cumulative value without using the CUMULATE function
Hi everyone. I would like to know how to calculate the cumulative value without using the CUMULATE function. Please refer to the Excel diagram. I would like to put FORMULA in the LINEITEM of CUMULATE. I would like to avoid using the CUMULATE function if possible, as it degrades performance. Best regards,
-
Changing switchover is giving circular references error
Hello - I'm trying to move forward the switchover date for 1 version in a model and I'm getting a circular reference error message. This is the first time that this has happened. Any ideas what would be causing this / how to fix? FYI - the error message shows a giant list of references that it says are impacted. Thanks,…
-
OFFSET v LAG v LEAD
Hi All, I understand each of these functions but could someone succinctly explain the difference. I would naturally lean towards using OFFSET when looking to pull and push data from different time periods so I have never actually used LAG or LEAD in a live build. Where would LAG or LEAD be used over OFFSET?
-
TEXTLIST over USER-list
Hi all, They TEXTLIST-function isn't allowed over the USER-list while this would be helpful in some cases. Can this be altered? All the best,
-
Move values from flat list to hierarchical list
Hello, Everyone! Please, help me to solve the issue. I have a Flat list with the -1 and 1 values. I have a Hierarchical list consisted from the same code from the flat list but in the hierarchy. There are more than 15 levels. I want to assign every -1 or 1 from the flat list to every element in the hierarchical list. The…
-
Level 2 Sprint 1 1.5.7.3
Hi Team, When reviewing 'Check your Work' my output is similar with the exception of the dimension at the top. Check your Work in the content section has no time dimension at the top only 'Has Data'?. My output includes a date, namely the relevant week. When I try to omit a time dimension, in this case 'week', I'm unable…
-
Native Version Filtering
Hi, Is there a way i can add the native version that has formula in my filtering ? See example below, i need to activate the boolean in my "Act vs FC" version. Thanks in advance for helping. Regards, Tom
-
Level 2 sprint 3 activity 3.3.4 TRA01
I have been trying to figure out the formulas in this activity, I know that YEARVALUE function would be used with LOOKUP function. I am not able to figure out so as to what the mapping dimensions should be for LOOKUP as P3 SKU and G3 Locations are not lists. These are only dimensions I can think of as of now. Please guide…
-
Retrieve the current user from another module
Dear Expert, Good day! Is it possible to get/retrieve the current user from Module 1 to Module 2 even there's no Users list used in Module 2? So that the user will no longer select/choose on the dropdown in Module 2. The reason why we didn't put the Users list in Module 2 because of workspace size issue. Please see…
-
Formula for subsidiary view item
Hi! I have a question about formula in subsidiary view. I have a line item with different dimensions. What should I refer to in the formula so it would work (and can be seen) in subsidiary view item? Other items in the module are in regular dimensions.. And I would like to use them in the formula for subsidiary view item.…
-
creating Sys Account SKU Filter
what formula should I use to check if the total of all product SKU volumes over all time periods the value is not equal to zero?
-
Formula to find the age
Hello, Can you please help me with an info? Is there any formula that can be used to calculate the age if we have the date of birth? Thanks
-
Anaplan "Concat" & "Nested IF" Best practices
Hi Anaplaners, I have a module with 5 Line Items, all formatted as text. I have to concatenate the first 4 and give the output in 5th. However , out of the first 4 only the ones which have a specific value will be concatenated. (Eg. if 1st is "ABC" only then it will be a part of concatenation else not.) So there can be 16…
-
Average 3 months data
Hi, For your assistance please. I want to get the average of the past 3 months, however, the average result should be post to the remaining months. In the screenshot below, I created three lines items: Commission % - input data Latest 3 Months Average (Comm%) - I used this formula MOVINGSUM(Commission %, -2, 0, AVERAGE)…
-
Unable to edit the cell
Hi, I'm trying to make the last cell "SDR Action Plan" editable but it doesn't allow me to do it. Please let me know what mistake I've made. Thanks.
-
Referencing models in another workspace in real time
Can a calculation referencing a line item from a model in a different workspace be accomplished in real-time? Or will it require other forms of interfacing?
-
Period() Function -- Driven by Model Calendar Settings?
Hi All, Was doing some review reading and saw the note on the Period() function, for which I've always been a bit "hazy". ...From the instructions, it looks like the key thing is that results of this one are driven by/determined by the settings in the Model Calendar ("Time Bounds"?): * Result must fall within the Time…
-
How to calculate Month to month Growth Rate?
Hi all! What is the way to calculate Month to Month Growth rate (from the beginning of the time scale) if I have Sales Volume by month at monthly timescale? I have: (Volume by Month - PREVIOUS (Volume by Month)) /PREVIOUS (Volume by Month)* 100% I wrote the formula but it doesn't match the math result (when I'm making…
-
Use CloudWorks to solve CurrentDate/CurrentTimestamp in Anaplan WITHOUT using third-party tools
As Solution Architect / Model builder, I would like to be able to create a "connection" in CloudWorks Anaplan using a webservice managed by Anaplan which automatically updates in the backend a file that contains the periodically updated CurrentTimestamp in UTC (something like "2021-02-01T14:10:45"). I will know this will…