-
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
-
My data in my Model is not being added correctly
Hi, Anaplan is not adding my data down my columns correctly. What is causing this? I have a pic of 2 columns from my Module. the formula is adding Line Items "Opening Balance (01):To #1917" The total of my Closing Balance (01) for 1/2/2019 should be $6,156,256 not $821,052. Thank you
-
Setting up a user filter on a composite list
I have a module that has country and accounts as dimensions. My accounts are part of a composite list that roll up to segments. I've created a user filter using another module to show only the countries and accounts specific to a user. My filter is working but seems to cut out the aggregated totals for the segments. When I…
-
Level 1 MB Exam- Activity 5
Hi, I'm working through the L1 MB exam and cannot figure out activity 5. The question asks you to update the formulas for the bonus and benefits lines, using a combination of data from the new role data and module SYS08. When I update with this formula: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %…
-
Time Setting Weeks
Hi, How can I limit the weeks to fall to its month only? In my screenshot, my Wk35 Aug 30 falls to the month of September. Regards, Tom
-
Effective date of Employee in a Location
Hi, Looking for a solution to get the effective date for working on a location(Result(output Required)). Employee 1 1. Got hired on 15th March so output to be 15th March for the period March. 2. Moved to US location in May and stayed there for 3 months, for July period the result to be 31st May(period since working at that…
-
Rank Formula Issue - Not Starting at 1
Hello, I am running into a strange issue with the rank formula. In the attached screenshot, you can see a line item with the formula: RANK(1, ASCENDING, SEQUENTIAL, CURRENT FLAG <> Previous Current Flag, Current Flag Mismatch) I have displayed all related line items. A screenshot of the filter on the view has been provided…