The way that the calculation is set up is when the W's with and without AVSC (same with the V's) define the total W and therefore, W as a total won't display at all because it is already accounted for. Instead of creating just one calculation, multiple calculations can be created to get the desired results. I have reattached your workbook.
Hope this helps!
IfThenHelp.twbx.zip 20.9 KB
Oh, I see! Thanks for the explanation and the help.