Forum Discussion

JosephGalvin's avatar
JosephGalvin
Data Storage
05-19-2022

Formula not producing correct results

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

Code-first Analytics

1 Reply

Replies have been turned off for this discussion
  • HamzaJ's avatar
    HamzaJ
    Data Integration
    05-20-2022

    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