This is not a VBA problem. It's easier.

The fact is:

I have a Pivot Table with 3 fields

1. Name by store
2. Budget units (Total)
3. Results (Units) This is calculate by count of the field.

I need to add a calculate field, with a formula

I used a Pivot Table option, formula, calculate field

The field Total appears 'Total' and the field Units appears without (') like
this Units.

I tried to add a calculate field and write a formula:

'Total'-Units.

The result does not work well.

Any one knowa, what's happening?