-
How to get the FY19 and the FY20 values in the same Line Item.
Hi need help on the below query. I have three line items. A, B, C where in A and B are the inputs and the C is based on the Formula. IF (PREVIOUS(C) + A + B) < 0 THEN -(PREVIOUS(C) + A + B) * 0.0386 ELSE (PREVIOUS(C) + A + B) * 0.0386 The Function previous gives the value of the previous month. But I want the value of FY19…
-
quarterly snapshot
numbers will be uploaded quarterly but in YTD figure, I need to plot the quarterly numbers. Q1 YTD will be imported in Q1 and I need to save it in my Q1 column Q2 YTD will be imported in Q2 containing both Q1 and Q2 numbers, I need to retain the Q1 above and get the number/result for Q2. By this time, columns for Q1 and Q2…
-
Add Revision Tag option disabled.
Hi , I have a model in Standard Mode, I need to create a revision tag but I see that revision tag option is disabled. Can someone suggest the possible reasons for the same as well as any workaround for the same? Is there a limit on the number of revision tags that can be created in a model? Any help would be appreciated.…
-
Large Ragged Hierarchy in Anaplan
Hello, Can some one help me on the best practices to follow on large Ragged hierarchy in Anaplan. i know that top down allocation will not happen properly in ragged hierarchy, Apart from these is there any constraints related to maintain the large ragged hierarchy in Anaplan. Thanks In advance!!
-
MAILTO - CC users with selective access
Hi All, I'm trying to add all users with selective access to in CC of an email to be send via "MAILTO". But can't seem to get it working. Did anybody already try something similar? Thanks,
-
model Building 1 Mapping Question
Hi, I have a question for the Model 1 Building Module REV02. The mapping is incorrect for the Volumes and I'm not sure why. Please advice. Screen Shot attached. Thank you
-
How to get a Formula to output a text.
Hi, Not sure what the Synthax is for a Formula to return a text is. I have my Line Item formatted as Text, but want to know if I'm on the right track with the formula. IF 'Y01 Collection_Funding'.Front Book=1 THEN &"WITH PH"& ELSE &"WITHOUT PH" Thank you
-
Would like to know how to make buttons on a Dashboard
Hi, I'm trying to create a Dashboard based off one of my Models in Excel and would like to know how to make them button like I have in my Excel Model (Image is attached for ex). I do not want them to be page selectors on my Dashboard. Thank you
-
Year To Date (YTD) summary column not showing data
Hi Experts, I created one module, in which I added Time Range i.e FY 18, Number of Periods = 1, and Aggregation as Year To Date. For testing purpose, I added some data in some periods. I can see total amount under FY18 (Summary column), but no data appearing under YTD column. Please let me know, if I have missed anything.…
-
Behavior of Time Setting in future fiscal years.
Hi Experts, I have a question about Time Setting in anaplan. Under Model Calendar, there is an option "Current Fiscal Year". At the moment, I can see FY20 as current fiscal year and can see past 5 fiscal years (FY15 - FY19) and future 5 fiscal years FY21 - FY25. As time setting is in-built functionality. Does FY15…
-
Past model building sessions
Where can I find the recorded past session?
-
How to copy actual month data to forecast month?
I have following module, which is used for manual % input. The percent will be input in a special cases. My problem is that I want to determine do I want to utilize current month (actual percents) for forecast month. I would like to see the functionality as follow: * If user will “tap” UsedInForecast? to Boolean lineitem…
-
Reference a value from a module but only from selected part of its list
Hi, I have a budget that is dimensioned by the complete charter of accounts, so both sales and costs. I'm in another module now where I want to reference the Budget module to get the SUM value of all its costs. If I take the budget line item straight in it will give me the total of both sales+costs, so I basically only…
-
Conditional formatting on LISS based on Collect() line item value
Hi, I have a financial reporting module with only one line item, Collect, which as the name suggests is collecting values from a LISS with the Collect() function. The LISS is a fake versions list that has actual, budget and actual vs. budget as list members. I now want to do conditional formatting to the "Actual vs.…
-
Copy same line item value to other/nexdt list item in same module
Hi, I have a module with 1 dimension, a list, and 2 line items: Line Item 1 (boolean) Line Item 2 (boolean) I want the Compare line item to populate the same value as Show has but to do so for the next list item in the list. Example: List: A, B, C. Then if the line item has Boolean TRUE for A, that should mean Line Item 2…
-
level 1 model building
Can someone please help me correct what I am doing wrong. I imported the employee.csv file but not all the columns came over into my model.
-
Level 2 Model Builder Training- DAT01 Sprint 1
I'm having difficulties loading the beginning inventory positions data into DAT01. My SKU fields map correctly, however the data is just not pulling through as I would expect. What am I doing wrong here?
-
Find value from other line item and populate it backwards
Hi, Module: Dimension: Time (Months) Line item: Amount, Proforma (both Number format) The Amount line item is imported based on imported forecast. I then want the Proforma line item to populate the first found value from Amount for all cells in current FY. Ex. Amount is 100 from August to Dec 2020. FY starts in Jun 20, so…
-
How can i simplify this formula
Hi, I would like to know how I can simplify this formula... (Cash Collected Forecast - Other Forecast) * IF 'S01 Time Filter'.Weekdays? THEN IF WEEKDAY(START()) = 1 THEN OFFSET('Y03 Securitization'.Ending RTR Balance, -3, 0) ELSE PREVIOUS('Y03 Securitization'.Ending RTR Balance) ELSE 0 / IF 'S01 Time Filter'.Weekdays? THEN…
-
Formatting Question
Hi, Is there a way to put in one Formula for Actuals and another Formula for Forcasting? I was thinking I might have to create two Line Items (one for Forecast and one for Actuals) and put those formulas into the separate line items? Is this thinking logic correct? Thank you