Hi,
I'm tryin to run the folling rule but it always return missing and i don´t understand why:
FIX ("Contratos",&Ano_Rea,"No Currency","No_Channel","No_SNC","01","AG01NE","20501",&Mes_Cont,"13244422322")
"Base"
(IF("INI_MES_CONT"->"Termos" <> #MISSING AND "INI_ANO_CONT"->"Termos" <> #MISSING AND "BASE_CALC_CONT"->"Termos" <> #MISSING)
IF(@ISUDA("Account","P_62222") )
"Base"->"SNC_62222"->"EUR" = ("Termos"/100 ) * @MEMBER(@CONCATENATE(HSP_ID_,@hspnumtostring("Termos"->"BASE_CALC_CONT")))->@PARENT(Customer)->@PARENT(Brand)->"Actual"->"All_Channel"->"SNC_71"->"Base"->"EUR";
ENDIF
ENDIF)
ENDFIX
If i run the rule like th following it return 62981 so the value of the member "Termos"->"BASE_CALC_CONT" is 62981:
FIX ("Contratos",&Ano_Rea,"No Currency","No_Channel","No_SNC","01","AG01NE","20501",&Mes_Cont,"13244422322")
"Base"
(IF("INI_MES_CONT"->"Termos" <> #MISSING AND "INI_ANO_CONT"->"Termos" <> #MISSING AND "BASE_CALC_CONT"->"Termos" <> #MISSING)
IF(@ISUDA("Account","P_62222") )
"Base"->"SNC_62222"->"EUR" = "Termos"->"BASE_CALC_CONT";
ENDIF
ENDIF)
ENDFIX
If i change the member "Termos"->"BASE_CALC_CONT" for 62981 in the first rule it return what i want, so i think the first rule should return what i want. What i'm doing wrong?
FIX ("Contratos",&Ano_Rea,"No Currency","No_Channel","No_SNC","01","AG01NE","20501",&Mes_Cont,"13244422322")
"Base"
(IF("INI_MES_CONT"->"Termos" <> #MISSING AND "INI_ANO_CONT"->"Termos" <> #MISSING AND "BASE_CALC_CONT"->"Termos" <> #MISSING)
IF(@ISUDA("Account","P_62222") )
"Base"->"SNC_62222"->"EUR" = ("Termos"/100 ) * @MEMBER(@CONCATENATE(HSP_ID_,@hspnumtostring(62981 )))->@PARENT(Customer)->@PARENT(Brand)->"Actual"->"All_Channel"->"SNC_71"->"Base"->"EUR";
ENDIF
ENDIF)
ENDFIX