Tuesday, March 3, 2015

Setting a calculated field to 1

ISNULL(NullIf(Max (coalesce(v1, v1, 0) +(coalesce v2, v2,0) + (coalesce(v3, v3,0)),0),1) Target

--Use a CASE

No comments:

Post a Comment