About neg177

neg177

How would I exclude Holidays? I have a Boolean Line Item called Holiday that marks if it is a Holiday or not. I was thinking the formula below, but at the seem time doesn't seem correct. Days()-Holiday? Thank you

neg177

Hi, How would I create a formula that would give me the number of days in a given month?

neg177

I'm well thank you for asking. I hope you are as well. It doesn't take me to that Custom Mapping option like it sometimes does. Just takes me to the option to manually map the dates.

neg177

Hi, I'm getting a mapping error with my dates because they are not formatted identically. How can I fix this without going in and mapping each date to one another manually? Thank you Pics attached

neg177

Hi, I'm trying to create a Module that has the List of Days of the week as the Rows. I will have to use theses rows over and over again like the Excel Model, but will only allow me to have them once and the days of the week have to share the same formula. How can I format this so I can have it set up like I have it in Excel? I have images attached. Thank you

neg177

Got it, I'm testing it out now. Thank you!

neg177

Wait Im kind of confused what the Boolean Line Item would be. Because I would want the formula to Divide the first Line Item by the Second Line Item, but the second line item needs to be the value eight months later. So for example If it was February, I would need to divide by the value in October. If it was March, I would need to divide by November's value...and so forth

neg177

Hi, I'm trying to create a function that divides two line items, but the second line item needs to be the value of the 8th month from the first line item. This is the function that I created. 'F01 Funding Breakdown'.Total Funding / IF MONTH(START()) = 1 THEN OFFSET('F01 Funding Breakdown'.Scaled New Originations, 8, 0) ELSE 0 I'm still not getting what I want with this function. please advise. Thank you

neg177

In the formula IF PERIOD(START()) >= Module B.Current Date THEN Sales[SELECT: versions.forecast] ELSE Sales[SELECT: version.actual] , sales is referring to the line item I want to forecast?

neg177

I'm going to give option 1 a try. Thank you

neg177

I guess the real question I'm trying to ask is what is the best technique to approach when Forecasting a Daily Model in Anaplan?

neg177

Ok, What are other routes I can go with Forecasting? Can I have my Module with just Actuals and then a Module with just Forecast? Or would the Switchover be a better bet?

neg177

Is it possible to do Switch over on a daily basis versus a monthly basis?

neg177

That works, Thank you

neg177

Hi, How could I break the Formula up to be more readable. Also the Formula was accepted but it is not pulling in any numbers. ROUND(ABS(((IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY(START()) = 1 THEN OFFSET(Total Eligible Principal, -3, 0) ELSE PREVIOUS(Total Eligible Principal) ELSE 0 + '(Paydown)') - 'Min. Asset Requirement') / IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY(START()) = 1 THEN OFFSET('Y01 Collection_Funding'.RTR, -3, 0) ELSE PREVIOUS('Y01 Collection_Funding'.RTR) ELSE 0), 2) Thank you

neg177

Hi, I would like to know if it is possible to make a line item that I'm drawing data into from a flat file to make the numbers coming in negative. I have a Flat File where the numbers are negative on the Flat File, but need them to be positive in Anaplan (Vice Versa). How would I go about this without completely changing my Flat File. Thank you

neg177

Thank you so much. The below are the formulas I ended up using. Once I get in Data I will see if they work. Thank you ROUND(ABS(((IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY(START()) = 1 THEN OFFSET(Total Eligible Principal, -3, 0) ELSE PREVIOUS(Total Eligible Principal) ELSE 0 + '(Paydown)') - 'Min. Asset Requirement') / IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY(START()) = 1 THEN OFFSET('Y01 Collection_Funding'.RTR, -3, 0) ELSE PREVIOUS('Y01 Collection_Funding'.RTR) ELSE 0), 2) IF '+New Receivables Pledged (% to Securitization) Cal Value' < 0.98 THEN '+New Receivables Pledged (% to Securitization) Cal Value' ELSE 0.98

neg177

Hi, The Excel Version of the Formula I'm trying to write is =MIN(ROUND(ABS(((UI20+UJ9)-UJ40)/Collection_Funding!UI3),2),0.98) The Formula I'm trying to use is MIN(ROUND(ABS(((previouse(total eligible principle)+paydown)-Min Assesset Requirment)/Previouse(Collection Funding!RTR)), 2), 0.98), which I do not believe is 100% correct. Functions I'm using (MIN, ROUND, ABS, PREVIOUS) Line Items (UI20=total eligible principle, UJ9=paydown, UJ40=Min Assesset Requirment, UI3=RTR) All my Line Items are Number Formatted. Please advice on how I should create this formula. Thank you

neg177

I believe I'm just going to copy and past it into another csv file that as the same exact layout I have in Anaplan, and use that as my flat file.

neg177 · ‎02-01-2021

Hi, I'm having trouble mapping this excel sheet. Attached is a snap shot of what I'm trying to map and also the excel sheet I'm trying to map. Please advice. Thank you

neg177 · ‎01-28-2021

Quick question, do I need Anaplan Connect to set up this automation through Task Scheduler in Windows?

neg177 · ‎01-27-2021

This was a great explanation. I'm going to set up and if I have any questions I will not hesitate to ask. Thank you

neg177 · ‎01-25-2021

Hi, I would like to know how I would update my model daily with my Flat Files that I have. i have created the actions and placed them on a Dashboard, but need to know how I would update theses files daily and run the actions? Thank you

neg177 · ‎01-20-2021

I removed the formulas like you said and the data mapped beautifully. Thank you

neg177 · ‎01-18-2021

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

neg177 · ‎01-18-2021

This function is not working, also I'm not sure how the logic for picking up the min value with the start and end of a month. Still confused on how this function will pick up the min value within a certain month for my Line Item. IF 'Y03 Securitization'.'Securitization Master Acct (x5000 Closing)'[ MIN : Actual Date] < 0 THEN This ELSE that

neg177 · ‎01-18-2021

Hi, I'm having trouble mapping this flat file into my Module. It will not let me manually map my data when I choose that option. Please advise. Pics are attached. Thank you

neg177 · ‎01-12-2021

I do have my SUM selected for my Summary, but not adding up my EOM totals. I have a pic attached to show what I'm talking about. Thank you

neg177 · ‎01-12-2021

How do I get end of Month Totals to show in a Module that is has a daily time dimension?

neg177 · ‎01-12-2021

It was the Versions issue. Thank you so much for your support.