Returned Value of a Formula Not Matching

[mphekin12]

Hello,

I’m hoping someone has seen this problem before and can suggest a solution.  I have a formula within a chart (Straight Table) that returns a value called Mix Builder which is highlighted in yellow on the attached snapshot.  If I use the same formula in a text box outside of the chart to display the Mix Builder, which is highlighted in green, the numbers do not match.

I believe the reason for this is due to the fact that we are multiplying each line item by a % of Total Sales within the chart, but outside
of the chart, that number becomes 100%.  Can anyone suggest a way to make these two numbers match?  I really need to use this number outside of the chart and it is imperative that they match.

Any information would be appreciated!

[alexandros17]

Aggr by the same dimension of the chart ...

[mphekin12]

Thanks for the reply Alessandro but I'm still not getting the correct answer.  The % of Total Sales is still 100%.

[Anonymous]

Hi,

where do you come up with 35.842 ?

is it a weighted average %?

Antoine

[mphekin12]

It is the Profit (which I didn't show on screenshot) / Sales.

[Anonymous]

Then I think your error is in the % of sales column.

look:

$ 80.174.229,00	25,255	23,20%	23730770,04	=+$B$9*C1*F1/100
$ 21.923.464,00	5,103	6,35%	7150995,488	=+$B$9*C2*F2/100
$ 55.260.982,00	15,473	15,99%	21917058,07
$ 46.483.843,00	13,166	13,45%	18774359,35
$ 117.958.437,00	33,283	34,14%	44410171,95
$ 14.051.721,00	4,699	4,07%	4880303,221
$ 9.606.138,00	2,729	2,78%	2953022,883
$ 52.868,00	0,293	0,02%	22673,49916
$ 345.511.682,00	100,001	100,00%	123839354,5

[#7]

Possible to attach a sample file with few records.

[mphekin12]

Eruditio,

I only posted the columns that were in the formula that I am trying to match up.  The numbers in the % of Sales column are correct.

Thanks!

[mphekin12]

Ajay,

Unfortunately there isn't a way for me to attach a sample file.

Thank you!