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.

BUDGET

INVOICE + ORDERS VS BUDGET $

INVOICE + ORDERS % BUDGET

NET SALES

NET ORDERS

INVOICE + ORDERS

FORECAST

INVOICE + ORDERS VS FORECAST $

INVOICE + ORDERS % FORECAST

<tbody>
</tbody>

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.