# Calculated field in pivot table returning zero value

#### Excel Chimp

##### Board Regular
I want to divide the Values below by a number. Here is the Calculated Field formula I created:
= Metric / 350

The calculated field returns a zero value rather than dividing the monthly value by 350.

What am I doing wrong? Thanks for any help.

 Sum of Actual Years Quarters Period 2015 Qtr1 Qtr2 Qtr3 Metric Jan Feb Mar Apr May Jun Jul Capital / Renovation 99400.11 78859.41 60647.06 43823.06 41719 45228.92 35025.93 Contract Services 25027.81 30997.37 25291.67 25090.77 25318.17 23805.57 38848.42 Expenses 174679.38 185646.86 201316.93 194692.14 182040.95 188814.46 248376.36 Expenses Controllable 121012.94 132640.31 138118.63 142027.87 129541.07 134961.01 194100.51 Expenses Non-Controllable 53666.44 53006.55 63198.3 52664.27 52499.88 53853.45 54275.85 Income 409379 414060.69 428893.69 432460.37 421891.16 426456.11 426989.21 Make-Ready 7743.93 16849.3 14684.82 21820.14 18566.33 30265.68 42300.96 Capital other 12939.53 12279.64 15300.69 12781.66 12617.27 13970.84 14393.24 Marketing 6666.03 2326.69 6562.98 7394.96 4791.24 7718.42 5980.76 NOI 234699.62 228413.83 227576.76 237768.23 239850.21 237641.65 178612.85

<tbody>
</tbody>

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

#### RoryA

##### MrExcel MVP, Moderator
It looks as though your calculated field should be using 'Actual' rather than 'Metric' for its calculation.

#### Excel Chimp

##### Board Regular
It looks as though your calculated field should be using 'Actual' rather than 'Metric' for its calculation.

Yes, that's it! Thanks so much for replying.

Replies
23
Views
626
Replies
0
Views
205
Replies
0
Views
232
Replies
0
Views
112
Replies
4
Views
354

1,127,876
Messages
5,627,418
Members
416,245
Latest member
Xterminat

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back