none
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