I want to have a value like this. Target field is X
X will be 0, if A is blank at source
X will be 0, if B is blank at source
X will be 0, if C is blank at source
X will be 1, if D has any value at source. (is, not blank)
A, B, C and D are values at source
X is the field at target which I need to populate
Please help