Hello Team,
While working on Model Building course 1, i am stuck at Activity 9.2.6. The issue is, upto 9.2.5, every output is matching. But for 9.2.6, after making the changes, the final output is not matching.
Don't think FY19 is a forecast year so your formula is returning zero. Does it work for 2021?
Appreciate your quick response, Tim. 😄
Please note, i tried entering time for 2021, but same result. The values are not getting updated.
Additionally, i tried to check on Level 1 Model Building sample which is provided at the start of the course. I changed the FY2021 Unit Price% to 5%, and checked the values in REV03 Unit Price Growth %. They are unchanged as well.
Thank you.
The price assumptions are at the product family level and you are pulling them into a product level module - try using a mapping table from product to product family and the lookup function, this may mean you also have to lookup the year rather than using year value...
Hello, I have a use case where a user will create a child if they want to make adjustments to an initial value entered at the parent level. The reason the "parent" list may not have children is that not all the list members will have adjustments. The users want to see all L1 items on the same grid as L1 items with L2 items…
We have a question regarding the behavior of the XL3dowriteback formula. Our understanding is that this formula allows writeback to be controlled on a cell-by-cell basis. In our operation, when we need to clear a previously written-back value due to an input error or similar reason, we do so by entering 0. However, when…
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
