-
[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…
-
Why is a line item referencing another where both have no overlapping applies to ok?
Lets say I have a line item LineA with an Applies To of Users, and a line item LineB with an Applies To of Organization. Anaplan lets me make the formula of LineA, "LineB". I understand the principal of using SUM/LOOKUP/SELECT etc. to find the values in each dimension to use where the dimensions are missing from the line…
-
Level 1 Module Building Exam - Model Building Activity 5
Help, I get all zeros for my results after building the formula in EMP02 Employee Expenses. When I set the Role to list, The text disappeared in my SYS08 Employee Details. I am two hours into this without a solution. Here are some screen shots: SYS08 missing data in Role column Role line item as a list "Role" Formula…
-
INV01 SPRINT 3 ISSUE
HI Team, I have few issues with the formula, its right or wrong? i have noticed 3 issues in my model 1. For Beginning inventory my formula is IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory here in week 2 of beginning inventory,…
-
Issues in module 6.8.4
I have set the hierarchy of G2 country but the error shows hierarchy not recognised.
-
Memory usage from text concatenation
We know that 2.02-04 Text Strings are bad for Anaplan models and that text functions and formulas using text are the slowest (slow in comparison to similarly-sized numeric formulas). One of the biggest contributing factors to the poor performance of text is the impact on the memory used by Anaplan. The following diagrams…
-
Use of CUMULATE function
Hi I'm trying to solve for the following: The screenshot below shows the two columns am trying to accumulate, Rows are the A1 Accounts dimension. The next screenshot shows I have a column for Country and is list formatted with G2 Country. Now, if I am trying to sum for each country (e.g. US, Canada, UK etc.) couldn't I use…
-
INVO1 SHIPPING METHOD FORMULA
HI I got stuck in the shipping methods where am trying to using all sort of formula but shipping methods showing different error my formula: 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Code, lookup: 'SYS08 SKU Details'.Supplied By] error : Data type mismatch: format other than LIST or…