I am working on the field which needs calculations like below
X= (0.1*A)+(0.4*B)+(0.3*C)+(0.2*D)
Where A, B, C & D are other attributes on the objects with number lookup. It is a possible value of A will be blank, in Clarity if any of the field values are blank it makes the calculated field X make blank.
Is there any way around this without asking the user to select N/A (Number value 0) for all the blank ones?