Created a calculated field in a Excel Pivot table but when I reference a text dimension/column in the data source/cache being 'Title' it returns 0 when it should return 10 (This formula is just me playing around with calculated fields)
= IF(Title="12 rounds",10,0)