Hi Craig

Add an extra column to your source data headed Test with a formula like
=IF(B2="BU",0,1)
Then expand your source to include the new column.
Drag Test to the area where you want it on the PT - presumably the Data area
--
Regards
Roger Govier

"craig" wrote in message
...
Hi, my question is..I want to use an If formula based on the Grp colomn
value
BU (see formula below), but it doesnt recognise the value as "BU", it just
returns the false value (value if false).

Pivot table rows are as follows
SO # Grp Cust Whse SO
311450 BQ BAKERS S 10-Nov-Tue
312385 0 MODERN S 12-Nov-Thu
312403 BU BUNNINGS S 12-Nov-Thu

I have inserted a calculated field with formula
=IF(Grp="BU",0,1)
The formula always returns 1
Thanks for your answer


__________ Information from ESET Smart Security, version of virus
signature database 4817 (20100129) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4817 (20100129) __________

The message was checked by ESET Smart Security.

http://www.eset.com