Formula not producing correct results

[JosephGalvin]

I am attempting to replace a value of N/A with another field in a table.  I continue to receive the value of "N/A" which is in the "Working Title" field with the formula below.  Is this the appropriate formula?  The actual value that appears in the working title field is "N/A".  The value is blank in the source software.  Thank you.  I have tried "is null" and other long if formulas.

case when [Working Title]=tostring('N/A') Then [Job] end

[HamzaJ]

Hi @JosephGalvin 

I am assuming you are trying to do this in the ElastiCube, because on dashboard-level this does not work. Strings cannot be used in a case-statement. 

I would try something like case when isnull([Working Title]) Then [Job] else [Working Title] end