I have tried a few different ways, in load statement and expression
=IF(Match(HIPAAStmt ='0' '-1','Yes' 'No'))
May be this:
=Pick(RangeSum(HIPAAStmt, 2), 'Yes', 'No')
Or just this
If(HIPAAStmt = -1, 'Yes', 'No')
This works because it automatically knows the second value should be no.
I make this harder than it really is.
Retrieving data ...