@mEEhan011 ,
Yea, this might not be fun, but if you have used SYS Modules, it might be a bit easier. Essentially, everywhere you have a formula that is pointing to the current M1 using parent(M2), you have to remove that formula and change the format and then re-add the formula when you are done. What I would suggest:
- make a copy of the model
- go ahead and create the new list (I will call it M1.5) with the appropriate members and have the parent list be M1. After this is done, go ahead and create a SYS Module for 1.5 and create a line item M1 list where the formula is parent(item(M1.5))
- Create a SYS Module (if you don't already have one) for M2 and do the same thing (create a line item for M1.5, format it to M1.5, but don't put a formula in it yet.
- Within the model, anywhere you are using M2 to get to M1, you will now need it to go to M1.5, but you can't just point the line item to your SYS M2 Module. You will need to remove the formula. Before doing this, I would recommend exporting the blueprint of each module that needs updated.
- Once the formula's are removed, now change M2 to rollup to M1.5 on the list (parent list). If it doesn't work, that means you missed a formula.
- Now that M2 is a child of M1.5, go to the SYS M2 Module and put the formula in for M1.5 (parent(item('M2'))
- you can go back to the modules and change the format from M1 to M1.5 where it is using M2 in the Applies To and update the formula to use the SYS M2 Module M1.5 line item.
Hopefully that makes sense, but if not, feel free to DM and we can setup a meeting to talk it out.
Rob
