Excel Chimp
Board Regular
- Joined
- Oct 30, 2008
- Messages
- 90
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.
<tbody>
</tbody>
= 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>