About CliveArmitage

Hi community I've completed the Level 2 Sprint 3 Exam, but not knowing the answer to the question that I got wrong is really bugging me. I think that it would be valuable for me (sanity and anaplan understanding) to know the answer. Is there some way that I can send someone my L2S3 downoaded certificate and they can send me the answer to number 4? Thanks Clive ... View more

Hi Community I'm not stuck, but I'm on the Inventory Ordering section, and I've a query about the SYS01 Time Settings By Week Booleans needed to run the INV01 model. 'SYS01 Time Settings By Week'.'First Week of Timescale?' has been created (using ISBLANK(PREVIOUS(Date))) and then the 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' has been created (boolean opposite of 'First Week of Timescale?' above) This is used in the INV01 module to calc the 'Beginning Inventory' item, with syntax IF 'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE blah Is this more efficient than using the 'First Week of Timescale?' item in the INV01 module with formula syntax of the type IF NOT 'First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE blah Apologies if I've missed something, but creating and using a second Boolean (opposite to the first) seems strange and I'm sure that there must be a reason that I'm missing (model size vs calculation simplicity between an IF loop and an IF NOT loop?). Hopefully I've explained myself clearly. Thanks Clive ... View more