Dear all,
We are trying to apply validation rule in prompt for the users based on the IF/ELSE and ELSEIF conditions
Below is our code
FIX ("Cash Ledger", "@relative("Project",0), "No Custom Dim2","No Custom Dim1","Actual","FY20")
{CurMth} -Dense member
(
IF(@ISMBR({Tgt_CC_Alloc}) AND @ISUDA("Entity","Grp-1") AND NOT @ISUDA("Entity","Grp-2"))
@return("Please select a valid entity which belongs to GRP1,error);- We want this logic to be applied -For if the user select the Cost centre is 150100CC which is not present in Grp-1 (UDA)then return a error and then calculation stop should there with a pop msg
ELSEIF (@ISMBR({Tgt_CC_Alloc}) AND @ISUDA("Entity","Grp-1"))
{Tgt_Acc_Alloc}->{Tgt_Prj_Alloc}->{Tgt_Loc_Alloc}=@round({Source_Acc_Alloc}->{Source_CC_Allocation}->{Source_Loc_Alloc}*{Source_Total_Alloc}*{Target_Alloc},2);
ELSEIF (@ISMBR({Tgt_CC_Alloc}) AND @ISUDA("Entity","Grp-2") AND NOT @ISUDA("Entity","Grp-1"))
@return("Please select a valid entity which belongs to GRP2,error);- We want this logic to be applied -For if the user select the Cost centre is 150101CC which is not present in Grp-2 (UDA)then return a error and then calculation stop should there with a pop msg
ElseIF @ISMBR({Tgt_CC_Alloc}) AND @ISUDA("Entity","Grp-2")
{Tgt_Acc_Alloc}->{Tgt_Prj_Alloc}->{Tgt_Loc_Alloc}=@round({Source_Acc_Alloc}->{Source_CC_Allocation}->{Source_Loc_Alloc}*{Source_Total_Alloc}*{Target_Alloc},2);
ELSEIF (@ISMBR({Tgt_CC_Alloc}) AND NOT @ISUDA("Entity","Grp-1") AND NOT @ISUDA("Entity","Grp-2"))
@return("Please select a valid entity which belongs to GRP1 Or GRP2",error); This one is working , msg. is popped.. when the user selects the entities not in UDA groups
ENDIF;)
ENDFIX
How make the msg pop up on the if elseif conditions, is there any alternate way like loop or array or Fixed loop to achieve this one.