Power Pivot Grand Total Calculation Error

[Avra]

I have a Power Pivot Table with a Grand Total calculation error. Here is the database:

MR Excel.xlsm
	A	B							I							P												AB				AF			AI							AP	AQ
1									Mailing List 1							Capitalization 2												Records 3				Convertible Class A Voting 4			Units Summary 5							Capital Summary 6
2
3		Mr Excel Database
4
5		Name							1							2												3				4			5							6
6		Mr Excel
7		Mrs Excel
8		Excel Jr
9		Total
10
Mr Excel Database

Cell Formulas
Range	Formula
I1	I1	=C4&" "&ZeoThermalDatabase[[#Headers],[1]]
P1	P1	=J4&" "&ZeoThermalDatabase[[#Headers],[2]]
AB1	AB1	=Q4&" "&ZeoThermalDatabase[[#Headers],[3]]
AF1	AF1	=AC4&" "&ZeoThermalDatabase[[#Headers],[4]]
AI1	AI1	=AG4&" "&ZeoThermalDatabase[[#Headers],[5]]
AP1	AP1	=AJ4&" "&ZeoThermalDatabase[[#Headers],[6]]

Here is the Pivot Table:

MR Excel.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2		Mr Excel Technologies LLC Capitalization Summary 2014
3			UNDILUTED BASIS		FULLY DILUTED BASIS
4			Class A Voting		Convertible Class A Voting			Units Summary		Capital Summary
5
6		Date of Purchase	All
7
8		Investor Name	Undiluted Basis Class A Units	Ownership Percent	From Convertible Debt	From Outstanding Warrants	Total Units Controlled	Fully Dilluted Units	Diluted Ownership Percent	Class A Invested Capital	Convertible Debt Invested Capital	Warants Invested Capital	Other Promissory Notes Payable Net of Interest Due	Total Invested Capital	Capital Invested Percent
9		Excel Jr	2,500,000	33.33%	0	0	2,500,000	2,500,000	33.33%	$ 25,000	$ -	$ -	$ -	$ 25,000	33.33%
10		Mr Excel	2,500,000	33.33%	0	0	2,500,000	2,500,000	33.33%	$ 25,000	$ -	$ -	$ -	$ 25,000	33.33%
11		Mrs Excel	2,500,000	33.33%	0	0	2,500,000	2,500,000	33.33%	$ 25,000	$ -	$ -	$ -	$ 25,000	33.33%
12		Grand Total	7,499,999	100.00%	0	0	7,499,999	7,499,999	100.00%	$ 75,000	$ -	$ -	$ -	$ 75,000	100.00%	What's causing this error?
13
14
15
16
Mr Excel

Why is the Grand Total calculation in error. The Grand Total should be 7,500,000.

 

[Fluff]

Duplicate to: Power Point Grand Total Calculation Error

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.