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
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
Just like the main question above, I wanted to try out the new feature on the board where you can you the insights panel to put additional cards. However, I wanted to synchronize scroll a card on the main board with the card on the insights panel but I can't find where it might be.
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…
