Unexpected Case Statement result
I've got a very strange issue with case statements in a calculated field. The field is supposed to check a boolean value (groups:isgenetics), if it's empty then return the first item in the Funding Strings value list, if it's 1 then return some static text. Here's the statement:
Then it works correctly. So somehow the calcuated result, the GetValue ( ValueListItems ( Get ( FileName ) ; "Funding Strings" ); 1 ), is screwing up the condition.
It's not a positional thing either, I tried swapping the order and the result is the same. Any ideas?