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
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…
