How are you defining scenarios? Are you using the native versioning as the scenario or did you create a "fake" scenario list? If using version, you can use the function of PREVIOUSVERSION() as mentioned in my other post. If you're using a "fake" scenario list, my suggestion is to create some sort of mapping module to tie each scenario list item to a previous version. You can then reference this module in your formula. Your first module will be dimensioned by the fake scenario list and 1 line item of “previous scenario.” Tie each scenario to what you want the previous to be. Your second module will need to be dimensioned by the scenario list and a few different line items for C. One line item will set C = B since this one possible solution to your formula. The other line item will set C = Previous C because this is the other option. Your final C line item will then do the logic to determine which of the other 2 C line items it will take based on the value of A. I hope this helps! - Taylor
... View more
@bdeaton, In the above comment you mentioned that you were able to enhance this process and allow the selection of multiple items in the same level of a hierarchy. We have the same need with our user access and are struggling to figure out a solution. This video was helpful but only provides an example of selecting 1 item from the hierarchy. Do you have any additional details around how you were able to modify the process to do a multi-select?
... View more