-
Count Function
Hi, How could I count days by 1) weekday type and 2) Actual data or not. Ideal result would show X day for "Weekend" for Actual data, Y day for "Holiday" for Forecast data.. etc. * Index is a "Day" list from 1 to 31. * Column "Weekday" and "Actual data" are manual input. * "Value" is a supporting column. Feel free to…
-
Unable to RANK from Lowest Amount When the Item Is Only One
Hello, I hope you're all doing well. I have this problem that's preventing me from proceeding on to the next steps. I'm trying to rank the basic salary from lowest to highest, by position. As we all know, even if employees have the same position, there are instances that they don't have the same salary. The idea is, I need…
-
Is there a way to hide zero value line items?
Hi All, Can someone help me how to hide zero-value line items in a model or dashboard (within the dimensions). regards Sudhir
-
Forecast Data using TIMESUM function
Hi Team, I have one situation, where I am calculating a Line-item in Forecast scenario using Sum of Last 12 months (from the Current Period). Need your inputs to help with the below model design. Scenario 1: Current period = Jan 2021 Actual Version = Jan 2020 till Dec 2020 Forecast Version = Jan 2021 till Dec 2021 (i.e.…
-
DCA based off of a user in a module
Hi all, Wondering if anyone knows of a way to matchup the user from a module with the user list used in the DCA module. Obviously you cannot lookup based off the user list, so wondering if anyone has a workaround.
-
Finding the next non blank field
Hi, This must be simple but it is driving me mad What formula do i need in the Next Non Blank line item to find the next non blank date? Thanks
-
Formula using Min Function
Hi, I'm trying to replicate this Excel Function in Anaplan. I want to make sure my Anaplan Function is picking up all the values for my Line Item from the begging through the end of the month, and not just the beginning and end month numbers. I have the Formulas below. Please advise. Excel Function…
-
Finditem in Subset (Works!)
In a prior post, I'd asked if there was a way to use the FINDITEM function to determine if a list item is a member of a subset. The answer at the time was no, but you could create a line item with an Applies To on the subset, and set the formula to TRUE, then you could create another line item with Applies To on the full…
-
Confused on how to use Min Function
Hi, I' trying to use a Min function to take the min Account Balance in a month. This is the function I thought of using but it is not working. Both are formatted as Numbers. 'Y02 Accounts'.'Closing Balance (01)'[MIN:'S01 Time Settings'.Day # of the Month] Thank you
-
Quarter value as numeric numbers
Hi All, Required a quick help in getting the quarter number as numeric format. For example in attached screenshot, need to get the value for second line item as entered. All Q1 Months should populate with numeric number 1, all Q2 should be populated with number 2 and so on.... Quartertodate() function gives a numeric…
-
Boolean between two dates
Hi, I have a module with three line items: "From", "To" and "Any", which are all Boolean formatted. I also have time as a dimension. "From" is just true for one month, which comes from another module, and the same goes for "To". My problem is within the "Any". I want that to be true for all dates between the "From" and…
-
Capturing uploading timestamp in a line item in module
There is a requirement where, when we are importing data in a module, the current timestamp when the file is uploaded in the module should capture that time in line item.
-
Need support with Time Management using DCA
Can anyone help me what's the best way to identify - Current Year Current Quarter, Current Year Previous Quarter, Previous Year Current Quarter using DCA and Boolean.
-
Level 3 Sprint 2 Section 4.5
Hi, Section 4.5 says to check my build on the Accounts Exception UX. I am not sure if there was an activity to build that. Am I supposed to build the UX pages basis the mock-ups we created in the beginning?
-
End of Month Totals in a Module.
How do I get end of Month Totals to show in a Module that is has a daily time dimension?
-
Circular Reference with CUMULATE
Hi All, I am trying to solve an excel model in Anaplan where my current value is a calculation of the cumulative of previous values. The calculation works fine in excel but I am unable to break this down in Anaplan. I am adding the screenshot for the logic of this model below. Any help or suggestions would be helpful.
-
P3 SKU 0 Failed Invalid parent
Hi on the Level 1 model building exam, I am trying to import the SKU csv and I get a message saying invalid parent and I dont know why. Wold you mind helping me ?
-
How to make Line Items into inputs?
Hi, I'm not sure how to make my Line Items into inputs(blue). They do not have formulas in them so not sure why they are not allowing me to make them inputs. Please advise. Thank you Pic attached
-
Call Center Functions: Agents must return whole number?
Is there any equivalent or trick to returning 'fractionalagents'? AGENTS(w, t, y, z) will always return a whole number. My stakeholders are interested in both whole/fractional agent calculations.
-
How do I get the total from one module to another?
In module 1, I have a count for resolved and unresolved. In module 2, I would like the total for unresolved items and resovled items. How do I do this? I know in Excel it would be a simple sum formula. Module 1: Module 2: Thanks!
-
ANAPLAN Optimization for N users
Hi , If we have users of around 10000000 in Sales team and we are using that list (Users) in one module so how can we optimize the structure of module as if that module page is published in Dashboard then it will take time at great extent to open and to load so how can we optimize the page of dashboard so that the user…
-
So long and thanks for all the fish - The final act
My beloved Anaplan community"How lucky I am to have had something so special that makes saying goodbye so hard” I can't take credit for that quote - I have to thank AA Milne for summing up how I am feeling right now.In a year of unpredictable events, I never expected to be writing this. As 2020 comes to a close, so does my…
-
Level 2 Sprint 2: assigning roles TO Product family managers
Hi Team, The global assumption DB created was only need to show to "Product family role". And each product family manager will only change "volume growth rate" to his assigned product and viewed the rest of the product family. I Assigned 4 roles as "Product family manager" and also removed their "WSA" rights : 1) I am not…
-
Level 2 - Sprint 3 - Activity 3.5.5 - SKU by Distribution Centre
Feeling lost how to go about creating module for this card All SKUs for a Distribtuion Center- any inputs please?
-
Same code at different levels of list hierarchies
Hi, I got a metadata dataset for the charter of accounts that uses the same code sometimes at different levels of the hierarchy. Although this is possible/works when creating in Anaplan for both Numbered and regular lists - should I avoid it and maybe create an additional import action that creates a unique code of…
-
Deriving the month/quarter value from the line item
Hi I have a line item ' Transaction Date' formatted to 'Date' . Sample value : 01-08-2021. I am trying to derive the Month,Quarter and Year from this Date value in the below sample format. Month: Jan 21 Quarter :FYQ1 FY21 Year:FY21 Is there any formulas to derive these values? Thanks Prabakaran
-
decimal places more than 15 do not total right:
Dear Team, I would like to seek for your enlightenment on this area. I tried to copied several times an amount (percentage in real number format) with a decimal places of 19-20. it copied correctly in anaplan and i selected the number format of significal number to 15 places. However, it does not total correctly. it would…
-
How to delete duplicated employee records due to movement
Hi, I have a scenario where we have created gap process to hire new resources, essentially adding new lines in our employee list. However one problem coming up is sometimes we created a gap and then an existing/internal team member applied and got the job. Not sure if there is a way we can somehow delete the original…
-
Trouble importing BookPrice
Hello, I am having troubles when I import the data from the Price Book that I downloaded from Anaplan Learning. The numbers imported are inserted with a multiplication of 100 (e.g 0.84 USD ==> 84 USD), so my margin calculation is all false! What should I do ? PS : I have applied the same Format for the line items as…
-
Level 1 Model Building Training
Hi, In Level 1 Model building Training, i have created an input Module as follow The next step asks to import the data to this module, as given below When i am trying to import the data, what should i map the 'Volumes' line item to??