Can anyone help me understand why the following order of the steps is wrong? I have tried two attempts but still can't get it right!!! Step 1. Build centralized dimensions in the model (time, version,…
I am stuck - I have a Boolean that I want to populate based off the value in a given list. If this was excel I would write the formula as If Pay type = H then True else false. But I know that I can't …
i have credentials to log in anaplan community.but while log in to the worksapce by using same credentials it showing as incorrect .while going to password reset, unble to get reset password to the ma…
I have a driver called "set to plan" which is just assigning the planned amounts to the forecast periods, but this is only happening for 2022 forecast periods. The previous driver Calc: IF Driver Meth…
Hello Community, I have created a module where I have set Fiscal Year Start Month as "April" There is some module where I need month to be started from "January"... What is the solution? Thanks in Ada…
Hi, How can i apply the selective access write only in my dropdown list ? I have a list with selective access both write and read and in my dropdown list i only want to allow users to select those mem…
Hi, Need help creating a formula that will look at LI for a rolling 5 day forecast and return back the max number of those 5 days. I set up a systems module that looks at the forecast for 5 days, and …
Hi Model Contributors, I just read a really interesting Community blog post by @AntonS where he outlined seven benefits of model building within the Anaplan platform (spoilers: #5 covers the benefit o…
Hello - I have a question which ultimately is related to using the users list in module design. Was hoping someone could confirm my theory, or even better, provide a more efficient way to set this up.…
Hi everyone, I am in need of a formula for specific line items from our P&L that calculates the previous year's YTD values. For example our YTD currently shows Jan 22 - May 22. Ideally I could have a …
Anaplanners, Running into a rather simple issue, wanted to use the anaplan mail to function with the body picking up few data from the module, for example: - Marks obtained by each student is stored i…
Hi! I am getting zeros in my data when I am using the LOOKUP function. What are the possible reasons for this? I am sure that I am using the function correct. The function works but the data only show…
Hi, I have a target module INP01 with 5 dimensions (P1, C5, Size&BPC, Time, and Deal Levels) and I need to bring values from another module DAT05 which has 4 dimensions (P1, C3, Size&BPC and Time) The…
I need to sum values inputed in months into a line item independent from time over a specific time period already determined by start and end date how can i do that please ???
Hi, I'm trying to do a calculation similar to the IFERROR calculation in excel but I can only seem to do the IFTHEN formula in Anaplan. Does anyone have a suggestion for this? The excel function is IF…
Hi Community, I have a question on how to minimize the model size of the client. Recently they ask to have an additional 2 Previous years on the model (which is done already). They added FY2017 and 20…
Hi All, I've one use case where I've to calculated payment according to payment frequency i.e monthly, annually and quarterly. I've system module dimensioned by lease where user enters lease start dat…