#DIV/0! for calculated field

[josephhung]

Hello,

I know if I create a calculated field in a pivot table with dividends of 0 or blank, it will show "#DIV/0!". However, I double check, my dividends don't have any blank or zero value, but I still get this message. I've attached a dummy dataset with my testing formula.

Basically I would like to create a calculated field "1U / Pkg size"...

Thanks a lot for the help!

Calculated field issue.xlsx

 

[Crystalyzer]

In your data the "Package Size" appears to be text. I converted it to numbers and then created the calculated field you want and it seems to work.

Calculated field issue.xlsx
	A	B	C
1
2
3	Row Labels	Sum of 1U	Sum of Field1
4	16005596	306	51
5	16005597	54	9
6	16005598	294	49
7	16005599	0	0
8	16005600	270	45
9	16005601	12	2
10	16005602	270	45
11	16005603	12	2
12	16005604	96	16
13	16005605	6	1
14	16005606	222	37
15	16005607	12	2
16	16005608	204	34
17	16005609	294	49
18	16005610	420	70
19	16005611	0	0
20	16005612	138	23
21	16005613	12	2
22	16005614	0	0
Sheet2