Switch not working correctly

[o59393]

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.

[PaulDBrown]

@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 · Accepted solution]

Hi @PaulDBrown 

I tried with double "==" and worked!

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

Thanks 🙂