| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to type correctly formula in calculated field in a pivot?
I want to properly type in the formula in a calculated field in a pivot.
E.g. formula=Average(field1+field2). I have a error message saying that the typing is wrong... Thanks for your help! |
|
#2
|
|||
|
|||
|
use a comma instead of a +
=average(Field1,Field2) "louloutte48" wrote: I want to properly type in the formula in a calculated field in a pivot. E.g. formula=Average(field1+field2). I have a error message saying that the typing is wrong... Thanks for your help! |
|
#3
|
|||
|
|||
|
Thanks very much for your help... working good now....
"bj" wrote: use a comma instead of a + =average(Field1,Field2) "louloutte48" wrote: I want to properly type in the formula in a calculated field in a pivot. E.g. formula=Average(field1+field2). I have a error message saying that the typing is wrong... Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
| How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
