So I'm trying to run a logic code, that fills nulls. The SEAL is same the same for all counties. My logic code below works for US and HK, however I'm still seeing nulls for IND and LUX. Can you please help?
IF IsNull([US SEAL])
THEN [HK SEAL]
ELSEIF IsNull([US SEAL]) AND IsNull([HK SEAL])
THEN [IND SEAL]
ELSEIF IsNull([US SEAL]) AND IsNull([HK SEAL]) AND IsNull([IND SEAL])
THEN [LUX SEAL]
ELSEIF IsNull([US SEAL]) AND IsNull([HK SEAL]) AND IsNull([IND SEAL]) AND IsNull([LUX SEAL])
THEN 0
ELSE [US SEAL]
ENDIF
Hey @ydklyfe,
Do you have any example data to test your formula on?
@ydklyfe Not sure how your data is structured but here is one idea for filling in the blanks dynamically:
Do try @IraWatt suggestion, but if you are building nestedif, would it be better to list out the most specific first? Like
IsNull([US SEAL]) AND IsNull([HK SEAL]) AND IsNull([IND SEAL]) AND IsNull([LUX SEAL]) first, then
IsNull([US SEAL]) AND IsNull([HK SEAL]) AND IsNull([IND SEAL])
and so on?
I will upload a dummy data soon.