Hello everyone
Why training course think that it is wrong formula?
Confirmed Purchase Order Receipt (INV01 Inventory Ordering)
IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0
@ER
Although it looks like the correct formula but if you have finished your level 2 and you are taking up L2 final exams then it indeed is wrong, because you will have to replace OFFSET with POST. That is why this exercise is very helpful as it helps you to understand the limitations of OFFSET and the use case of POST. Please go back to the training and follow the order because immediately after using OFFSET there is another exercise which asks you to replace OFFSET
Note: POST will not take three parameters in its syntax, only 2.
Hope that helps
Misbah
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
