Setting a calculated field to 1

You just need to have an IIF() statement as a wrapper on you existing logic, like:

IIF(Max (coalesce(v1, v1, 0) +(coalesce v2, v2,0) + (coalesce(v3, v3,0))=0,1,Max (coalesce(v1, v1, 0) +(coalesce v2, v2,0) + (coalesce(v3, v3,0))) as Target

---

~manoj | email: http://scr.im/m22g

http://ift.tt/LOIag3

MCCA 2011 | My FB Page