Hi Mark,
You can read literal value parameters inside a dynamic calc.
I will suggest using Difference Between Columns in the Cube view itself rather than having a parameter inside a dynamic calc.
In the above example I am using Difference Between Columns CVC to get the difference between the scenarios. The Column names are self-explanatory you can setup your cube view like shown above. This approach is dynamic and works similarly just like a dynamic calc but will be easier to maintain. In your case you can replace Difference Between Columns CVC with Column Better/Worse CVC [GetDataCell(BWDiff(CVC(Col1), CVC(Col2))):Name(BetterWorse Difference)] rest everything will remain the same.
Thanks, Omkareshwar
Archetype Consulting
