Since Site is a text field, the calculated field will evaluate all Sites
as zero. So, materials for all sites will be multiplied by 2000.
Perhaps you could add a column to the source data, and do the
calculation there, then add the new field to the pivot table.
Tim wrote:
Hi,
I want to create a calculated field that uses an if to base its calculation
results.
Therefore i have a field called Site which is a text and another field
called materials which is the number of materials.
=if(Site="Mexico", materials*300, materials*2000)
I have tried this and it doesnt compute based on the Site field or at least
the text isnt matching as I have changed the Site to Mexico and it still
calculates based on the 2000 amount. Anyone know why?
Thanks,
Tim
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html