Stuck with the Expression Totals in display of Average

[#1]

Hi friends ,i am stuck with  one Measure which is not giving desired Output,when i tried to do validations in Excel it is giving desired/Expected o/p.Please look into Source and Attached QVW.
I have filtered DIV-8;

Date is 2015-03-16

I have measure have values in % when looking into individual rows values are getting expected.But where as when looking at Total sum or Avg sum getting as different in Target Measure .Please correct me i have attached source for Reference in sheet 2?

[sunny_talwar · Accepted solution]

PFA

Best,

Sunny

[#3]

Really helped thanks for solution

[sunny_talwar]

I am glad that it was helpful.

Best,

Sunny