About AlecWainberg

1. You can try to use the Days function which should yield a 1-7 for the date period depending on the day of the week. 2. Then in your formula you can use an IF statement similar to below: IF Day of the Week = 1 ----> (This should either be Monday or Sunday depending on your model calendar -> make sure the number is equal to Monday's day of the week) THEN OFFSET( 'Y01 Collection_Funding'.'Securitization (including WO)', 3)  ---> This will bring in the value from 3 days prior to the Monday (i.e., the previous Friday) ELSE OFFSET('Y01 Collection_Funding'.'Securitization (including WO)', 1) ... View more

Hi, You may want to try a formula similar to below: Amount [Lookup:  'S01 Time Filter'.End of the Month] Where: Amount = Balance either weekly or daily that rolls into the month ''S01 Time Filter'.End of the Month' = is a time dimensionalized module that identifies the Month period ... View more

Hi, Here is a helpful link if you need to round to nearest multiple: https://help.anaplan.com/en/2d24d30a-e10a-4fdc-850a-a8b4a2d1625b-MROUND   ... View more

Hi, This link may be helpful for more information about dashboards. LINK ... View more

Hi Tom, Take a look at the Model Calendar in the Time Settings. You may want to test different calendar types. ... View more

I think Akhtar's solution would be the best path forward. Creating the system module for costcenter selection and using the import functionality should work great. ... View more

Im not sure what you mean by 'past session' but if you are trying to review model history you can click the Model Settings icon within the model and click the History tab. This will enable you to view all model changes (both structural and data). ... View more

Hi, You may be able to use the 'Ask each time import is run' functionality within the import settings for the Time Mapping to identify which Quarter to import the YTD value to. ... View more

Hi sujeethkumar, If I am understanding the ask correctly, the user identifies the length of the period as well as M1 and you would like the rest of the 'M' fields to autopopulate. If this is the case, all you need to do is right a formula for M2-M5 that references M1. For example, M2 formula would just be M1+1 and M3 formula would be M1+2. You can add in additional logic into the formula that looks at the LEFT(New Period (Quarter) ,1) which should result in the number of months within the period. ... View more

Hi neg177, You can also try to use the OFFSET function. For example, if you want to pull in next month's amount: OFFSET(Amount Line Item, 1, 0) should yield the desired result ... View more

One thing I would like to add is that although there can only be one model being reference on a single page, you can have multiple models be represented within a single app (they just have to be separate pages). This can be helpful if you want to have an Admin dashboard that looks at the datahub and end user dashboards that look at prod within the same app. ... View more