Pivot Table Calculation #Name Error

[Hoosier03]

I am using Excel 2016.

I added a column to the data set that my Pivot Table is pulling from and one of the calculations is giving me a #NAME ? error now. How can I fix this? The columns I am using are below. The error is in the third column (Invoice+Orders % Budget). The column I added is Net Sales 2. I tried changing the name of Net Sales 2, but that did not work.

[TABLE="width: 945"]
<tbody>[TR]
[TD="class: xl268, width: 58"]BUDGET [/TD]
[TD="class: xl268, width: 123"]INVOICE + ORDERS VS BUDGET $ [/TD]
[TD="class: xl269, width: 123"]INVOICE + ORDERS % BUDGET [/TD]
[TD="class: xl274, width: 70"]NET SALES [/TD]
[TD="class: xl270, width: 56"]NET ORDERS [/TD]
[TD="class: xl270, width: 123"]INVOICE + ORDERS [/TD]
[TD="class: xl271, width: 129"]FORECAST [/TD]
[TD="class: xl272, width: 126"] INVOICE + ORDERS VS FORECAST $ [/TD]
[TD="class: xl273, width: 137"]INVOICE + ORDERS % FORECAST [/TD]
[/TR]
</tbody>[/TABLE]



Thanks,

Rodney

 

[DRSteele]

Let's see. I've had problems in PTs when I used the Alt_Enter character (i.e., the carriage return within a cell) in the Table names. Could that be what's going on here?

 

[Hoosier03]

Let's see. I've had problems in PTs when I used the Alt_Enter character (i.e., the carriage return within a cell) in the Table names. Could that be what's going on here?

I figured this out. What I did was go into the calculated field. The formula said #Name/#Name. For some reason adding a column broke the formula. It has been working fine once I changed the formula.