It might be too late but maybe other are interested:
'Value' = (
CASE
WHEN t.Result in ('Fail','No','0.00') THEN '0.00'
WHEN t.Result in ('Pass','Yes') THEN '1.00'
ELSE CONVERT(VARCHAR, CAST(t.result AS float))
END),
OR
'Value' = (
CASE
WHEN t.Result in ('Fail','No','0.00') THEN 0.00
WHEN t.Result in ('Pass','Yes') THEN 1.00
ELSE CAST(t.result AS float)
END),