Alternate State - Total Variance % Issue

[#1]

Hi,

I am conducting a comparitive analysis using Alternate States comparing my Clients Average Charges to a Competitor / Group of Competitors Average Charge.  Everything in the table below work fine with the exception of the Total for the Variance %.  If you look at it, it states 21.3%.  It should be 46.5% ($89.9M / $61.3M - 1). I understand why it doesn't work, as in I am Total Mode Expressions under the Expressions tab.  Can you anyone provide guidance on an expression that will result it the correct Total Variance %.  Listed below is a screen shot and a list of formulas being used in the table

[sunny_talwar]

Your expressions seems to be right, would you be able to share the sample to play around with it?

[#3]

Hi Sunny,

Thanks for your response.  I will upload a sample version of the file shortly.

Brian