Can a Pivot Table Calculated Field Return Text Values?

[gsheridan]

I'm trying to use a Pivot Table Calculated field formula of IF(Column 50>20,"YES","NO"). It is only returning #VALUE . The formula works when I change the return values to numbers. Is it not possible to return text from a pivot table calculated field?

 

[Fazza]

A field can be created - using SQL. Could be like,

SELECT IIF(NameOfFieldToCheck > 20,'YES,'NO') AS [Name of New Field]
FROM SourceData

there will be many old threads where I have examples

PS here is one of many, https://www.mrexcel.com/forum/excel-questions/437647-pivot-table-formula.html