Forum Discussion

o59393's avatar
o59393
Post Prodigy
5 years ago
Solved

Switch not working correctly

Hi all

 

I created a switch function which should return In, out or blank.

 

The blank should be returned only if the result column is blank:

 

 

As seen below, the column logic for the first results are showing blank, but the result is 0, therefore it should return an in or out.

 

This problem is only happening to me with 0 values under the result column. Are results are labeled as decimal.

 

Do you know what could be wrong?


Thanks.

  • o59393's avatar
    o59393
    5 years ago

    Hi PaulDBrown 

     

    I tried with double "==" and worked!

     

    'Append (Sludge)'[Result]==BLANK(),BLANK(),
     
    Thanks 🙂

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion

    o59393 

    Not sure if this will work, but try ISBLANK(Append [Result], BLANK(), 

    in the first line of the SWITCH function (instead of the expression Append [Result] = BLANK(), BLANK() )

    • o59393's avatar
      o59393
      Post Prodigy

      Hi PaulDBrown 

       

      I tried with double "==" and worked!

       

      'Append (Sludge)'[Result]==BLANK(),BLANK(),
       
      Thanks 🙂