Forum Discussion
o59393
5 years agoPost Prodigy
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.
Hi PaulDBrown
I tried with double "==" and worked!
'Append (Sludge)'[Result]==BLANK(),BLANK(),Thanks 🙂
2 Replies
- PaulDBrownCommunity Champion
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() )
- o59393Post Prodigy
Hi PaulDBrown
I tried with double "==" and worked!
'Append (Sludge)'[Result]==BLANK(),BLANK(),Thanks 🙂