All text has the value of zero, so you can't test for specific text in a
calculated field.

Maybe you could add a field in the source data, and use a formula to
test Field1. Then, sum this new field in the pivot table.

HL Questions wrote:
How would I write the function in an Inserted Calculated field to a Pivot
Report to search Field1 for "Prospects", if present, insert amount from
Field2, if not, return 0?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com