Hi. I have a question about weekly statistic forecast model. In this model, can we control the difference of weeks in another year?   Suppose that, some food's demand will increase dramatically on 01/01(New Year). ・2014/01/01 - Week 1 FY14 ・2015/01/01 - Week 52 FY14 In this case, I think we cannot control the Weekly Seasonality.   This case will happen in another situation(ex) Christmas, Halloween). ... View more

Hello,   I am getting stuck on this same issue. Please see screen shot attached. I keep getting an error message.    Thank you very much.  ... View more

There are so many things that I loved about new modelling experience but here are my top two picks which I loved the most.   1. Ability to open Lists, Line Item Subsets, Modules and Dashboards in their own tabs. This removes the need to go back and forth between Modules->Lists->Line item subsets. 2. Line item Subsets(LIS), being carved out of General Lists Section & getting their own well deserved place.   What's your favorite?   ... View more

Hi,    Need help replicating this Excel Formula. The Anaplan formula we created is not working.    Excel Formula  =IF((WR20+WR26+WR27+WR29+WR28+WR5*0.95+WR31+WR32+WR35)-WR40>0,IF(WR29+(WR5*0.95)+WR31+WR32+WR28-WR35<0,0,WR5*0.95),0)   Our Formula  IF 'S01 Time Settings'.Actual Date <= 'S02 Time Admin'.Last Actual Day THEN PFR Value of Receivables * 0.95 ELSE if (Total Eligible Principal + 'Interest Acct (x1001)' + 'Securitization Master Acct (x5000 Opening)' + 'BALANCING FIGURE FOR x5000' + PFR Value of Receivables * 0.95 + Cash Collected + '(Cash Sweep to Wells)') - 'Min. Asset Requirement'>0 then if ( IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY(START()) = 1 THEN OFFSET('Securitization Master Acct (x5000 Closing)' , -3, 0) ELSE PREVIOUS('Securitization Master Acct (x5000 Closing)' ) ELSE 0)+(PFR Value of Receivables*0.95) +Cash Collected+'(Cash Sweep to Wells)' +'BALANCING FIGURE FOR x5000'-Excess Funding Sweep<0 then 0 else PFR Value of Receivables*0.95 else 0 ... View more

Hi,   I'm trying to replicate the Excel Formula in Anaplan below. I'm trying to use the AND function, so i made two Boolean Line Items and combined them to satisfy the condition. The formula worked but no numbers are showing in my line item. please advise.    Excel Formula  =IF(AND(Accounts!WP32<3000000,MIN(4000000,WP27,WP41-2000000)>0),MIN(4000000,WP27,WP41-2000000),0)   My Formula    IF 'EFS to WFA Calc1' AND 'EFS to WFA Calc 2' THEN MIN ( 4000000 , IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY ( START ( ) ) = 1 THEN OFFSET ( 'Y03 Securitization (Actuals)'.'Excess Funding Account (x1005)' , - 3 , 0 ) ELSE PREVIOUS ( 'Y03 Securitization (Actuals)'.'Excess Funding Account (x1005)' ) ELSE 0 , ( IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY ( START ( ) ) = 1 THEN OFFSET ( 'Y03 Securitization (Actuals)'.'Excess Collateral / (Deficit)' , - 3 , 0 ) ELSE PREVIOUS ( 'Y03 Securitization (Actuals)'.'Excess Collateral / (Deficit)' ) ELSE 0 ) - 2000000 ) ELSE 0 ... View more