Copy the field if value is Null

[prabunakil]

how to write script if the childmaterial field is null, copy the material value to the child material value.

but if child material value field have items, then no need to do anythings.

[sunny_talwar]

May be this

If(Len(Trim(ChildMaterial)) = 0, Material, ChildMaterial) as ChildMaterial

[Marco]

If( IsNull(ChildMaterial), Material, ChildMaterial)     as ChildMaterial

Marco