-
why is the summary not showing even when its enabled...
i have to refer sum in another module but it shows 0 since the sum is not showing here
-
Ability to Comment Code
The ability to put comment blocks and indents within your formulas, so as to allow model builders to better document and format their code within the models for readability and understanding purposes. This will help align Anaplan's language back to the basic features all other development languages used in an enterprise…
-
Current Date and Time
It would be great to have a function to get current date and time. Timezone settings could be common for all users and maintained in the settings section
-
Planning Gross Margin % and other Ratio metrics at levels above the bottom level
Pretty much everyone would agree that Gross Margin % (GM%) is a REALLY important metric when planning your business. It’s a key performance indicator for healthy past performance, and a key driver for future investment decisions and performance management. Employees are frequently bonused on revenue and margin goals – so…
-
Level 2 Sprint 3 3.3.6
Hi, I'm having difficulties in the Shipping Cost and Final Shipping Cost line items. The formula I used for both: Shipping Cost: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Final Shipping Cost:…
-
Summing on Period (Quarter)
Hi, I need some help in summing on the maturity period (quarters). Module 1: no time dimension, standing data showing loan amounts in various currencies, and maturities. Module 2 is dimensioned by time (quarters) and the loan amounts are converted at the quarterly FX rates. Module 3 is dimensioned by time (quarters) and I…
-
Calculating the average of a balance sheet item for quarterly / annual totals
I have a number of balance sheet accounts (e.g. Closing Receivables*) for which I need to calculate the average value. This should be calculated as follows: - Monthly: average between the current month and prior month value - Quarterly Total: average of the last 4 data points - Annual Total: average of the last 13 data…
-
L2 Conclusion - REP05 Local Currency
Is there any issue with the formula for Local Currency? - Although it's fetching the correct result, want to check if there is anything else I'm missing. regards Sudhir
-
Use formula to integrate data at multiple levels of list hierarchy
Hello, my model has a list hierarchy of "FND01 Fund" and "FND02 Series". FND01 has a top level of "All Investments." The model also contains three modules with data values at each level of the hierarchy - Total, Fund, and Series - and I want to integrate this data into a unified report as shown below: I need to write a…
-
3.3.5.3 Check your Work
My numbers are slightly off for some of them. I am not sure if one of my formulas is messed up, or what the issue is. If anyone can maybe point me in the right direction.
-
Today's Date
Hi, How can i refer Today's Date in a formula so as the values would change every day based on that days date. For e.g. if its 09th june then the formula should give result as 09th june . The next day i.e. 10th june the value should get updated to 10th june. Is there any such functionality or formula available inside…
-
Confirmed PO Delivery - offset function
Hi i am trying to determine the formula of this line item - confirmed PO Delivery for INV01 inventory ordering module in Sprint 3 was working on the hints given to use offset function and if PO request if 1 came up with this but couldn't quite figure out how to use the offset function if PO submitted = 1 then offset ( ?,…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi. requesting assistance in this part. I am not sure what I am doing wrong. I have transfer the file as directed but the number for forecast do not match. The data should be like this. Thank you
-
New Function To Convert Date Format to Text Format
It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function. Best practice would dictate to split these functions out but this increases clutter and causes unnecessary calculations in models.
-
Return True if any Cell Value Within a Time Range Meets a Condition
Hello, I'm trying to display a submit checkbox (boolean) on the dashboard. However, I only want the checkbox to be available if the cell value for all years have a value greater than 0. The years you see in the image is a Time Range (so, not Model Calendar). I would appreciate any insights on how to approach this. Thanks.
-
12.4.3 Activity: Create Saved Views for Size Margin Report - ***Numbers are off***
I can not seem to understand why my numbers are off. Please help, I have been staring at this for 2 hours
-
why are the values not rolling up to parent by default in attached photo
-
3.5.5 Activity: Create Distribution Center Summary UX Page
HI, struggling a little to create below view I am able to achieve below using DAT01 but not able to remove the summaries.
-
Option to not include current period in YTD calculation but in YTG instead
Description of the enhancement required: YTD calc should NOT include the current week and YTG should include the current week. How would this engancement improve your processes: I do several YOY indexes and they are all incorrect because of this. When I compare YTD this year to YTD prior year there is always extra data in…
-
Today() Function
I'm wondering why in Anaplan we can only have to input current period in Time. As we're using Anaplan as Supply Chain planification tools and we work really at planning on days level. So it's necessary for us to determine "today"'s date. The solution we use now is to launch an automatic import and update the "Today" item.…
-
How to use the RANK function
Hi everyone. I would like to use RANK function and extract only the data for the most recent date. However, the module have over 10 million cells. RANK function cannot be used... What should I do now? The following error message is displayed. Best regards.
-
REP04 L1 - Datatype error
Hello, I am completing the Level 1 Model Builder but am getting an error during one of the exam questions. I am pretty sure my formulae are correct but i dont understand what the error is telling me nor what to look to resolve. It is: 'Datatype mapping used for aggregation doesn't match any dimension of the result'. Can…
-
3.3.5.2 Inventory Ordering Module Formulas
Hi, From 3.3.5.2 Inventory Ordering Module Formulas I am not getting correct output for 2 line items - Beginning inventory and shipping time weeks. Beginning Inventory - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory…
-
what would be the formula for referring Previous year value in current year ?
For example, I want to refer the value of last year july 2022 in current month July 23. the line item is Past year revenue where I just want to show same month revenue from previous year, how could I achieve that?
-
Week Coverage, also known as forward coverage or stock cover
A description of the enhancement requested Week Coverage, also known as forward coverage or stock cover. As an example we have Forecast Sales and Current Stock. Formula should calculate how many future periods of forecast will be covered by Current stock. This is achievable in Anaplan with below function: Look Forward +…
-
what does item() and code() do in lessons 6/7?
trying to figure out what each element in CODE(ITEM('E2 Employees#')) does - i have read the documentation https://help.anaplan.com/41298b7a-e877-40e8-8cfa-8d7009d8686f-ITEM and https://help.anaplan.com/0e20099c-af47-4343-9ad9-3a20b580d2de-CODE but still can't grasp the idea: what does item return? then what does code…
-
1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
-
Unit Testing is for finding bugs, not show correctness
Architect, Builders; Having worked projects with hundreds of bugs, the natural question is how did this happen? The solution passes User Acceptance Testing means that it was adequately tested. This could be a paradigm shift for some in thinking about unit testing. Doing a quality job of it adds time to get a solution to…
-
how to calculate WEEKNUMBER of a particular date in a year
Hi Anaplanners, i am stuck with one the calculation ,which requires me to calculate WEEK NUMBER of a date in the year.In excel we can use WEEKNUM Function to get the number of the week . eg,WEEKNUM(2020-03-02) = 10 How can i achieve this
-
Want to match a property that one data source has to another data source
Hi, I currently have two different Data Sources in my Model (D01 & D02). They both share a MID and a CID that can link the data together. I need to be able to look up my data in my D02 Module by a List named Legal Process. I'm having difficulties making this List match the data in my D02. I know I can potentially create a…