cancel
Showing results for 
Search instead for 
Did you mean: 

Formula not producing correct results

JosephGalvin
7 - Data Storage
7 - Data Storage

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

1 REPLY 1

HamzaJ
10 - ETL
10 - ETL

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

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request