Clarity

 View Only

Calculated Attribute - NVL like function

  • 1.  Calculated Attribute - NVL like function

    Posted 13 days ago
    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?