| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated field in pivot table, simple Average formula
I can't get this formula to work for me, i've formatted it several different
ways and still get the general formula error. The formula works fine outside of the pivot table on the date, just not in the calculated field. Any ideas please? none of these work... =sum('TotalDollarException')/countif('TotalDollarException',"<0") or =('TotalDollarException')/countif('TotalDollarException',"<0") or ='TotalDollarException'/countif('TotalDollarException',"<0") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Field- Help | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
