This ??

=IF(AND(B2="Active",D2=0),D2,IF(D2=0,C2,D2))