LOOKUP not behaving as expected on production list
I'm trying to understand why using LOOKUP on custom versions from a SYS Constants module isn't behaving the same as SELECT.
I recently converted all of our custom version lists to production lists to help save space in the DEV/UAT model. As part of that change, I updated all SELECT statements referencing custom versions to use a LOOKUP from that version in a SYS Constants module.
Formula = MRR[LOOKUP: SYS Constants.Forecast]
FY24 MRR Forecast Version = 100
FY24 MRR Alternate Scenario = 90
What could be causing the Alternate Scenario MRR to be different from the Forecast MRR when the formula is looking up the Forecast version? I found a solution on the forums (see screenshot) that fixed the issue for me, but I'm not using list subsets with our versions so the explanation as to why it fixes the issue doesn't make sense to me.
My goal is to understand when a LOOKUP in a SYS Constants module will suffice versus needing to put the LOOKUP line item in the corresponding SYS List module.