Help with a calculated field in a PivotTable RRS feed

  • Question

  • Hi, I am trying to write a formula for a calculated field inside a Pivot Table.   I want to return the value 1 if the row value is equal to "New York", and zero otherwise.  My formula is


     =IF(ISNUMBER(FIND(City, "New York" ) ),1,0 ) 


    However, the formula always returns zero.   Please see the attached screen shot.


    Thanks, Ben.

    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Thursday, November 14, 2019 7:55 PM

All replies