Not sure you're trying it via calculated fields. Aren't you able to get the
desired results directly and easily in the pivot if you place
"Pipeline_Status" into the ROW area, and "POL_PREMIUM" into the DATA area
(set to SUM)?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Pat Dools" wrote:
I am trying to make a formula field that will add up 'Premium $' when my
'Status' field has a certain value and show that sum in the Data Area of a
Pivot Table report.
For example, I have this formula field:

= IF(Pipeline_Status= "In Pipeline",POL_PREMIUM,0)

Where 'Pipeline_Status' is a text field and 'POL_PREMIUM' is a currency
field in my Pivot Table source data. But, when I add the formula field to
the pivot table, I get '$0.00' for the value.
I would like to be able to evaluate the 'Pipeline_Status' field for
different values, and put the sum of the records that contain those values
side-by-side in the Data Area of the pivot table report. What am I doing
incorrectly here?