Hi Experts,
I would want to double concatenate but its not working, not sure what is the issue in smartlist retrieval.
In the below rule, what I am trying was, I want to calculate STI by Basic Salary (which is assigned to Grade) * Grade percentage
Eg:
For Account ‘V2STI’ → 50%
Basic Salary For Grade (Smartlist) V2 → 300000
Result: STI should be 150000
I'm tying the below rule to concatenate ‘STI’ with Smartlist grade value i.e V2 but its not working
Business rule:
Fix (@Relative("OWP_New Employees",0),"OEP_Forecast","FY25",&OEP_FcstMnth:Dec,
@Relative("All LOCATION", 0),
@Relative("Input Currencies", 0),
@Relative("Total COST_CENTER", 0),
@Relative("Total LINE_OF_BUSINESS", 0),
@Relative("OWP_Total Jobs",0)
)
/* Basic salary →no property is a grade value*/
DataCopy "OWP_Basic Salary"->"No Property"->"OEP_Working" to "WF_STI"->"No Property"->"OEP_Working";
Fix ("OWP_Expense amount")
"OEP_Working"(
If ("WF_STI"->"No Property" == @MEMBER(@CONCATENATE(@CONCATENATE("HSP_ID_", @Name(@hspnumtostring("OWP_Basic Salary"->"No Property"))),"STI")))
"OWP_Earning2"=("OWP_Basic Salary")*(@MEMBER(@CONCATENATE(@CONCATENATE("HSP_ID_", @Name(@hspnumtostring("OWP_Basic Salary"->"No Property"))),"STI"))->"No Entity"->"No Year"->"No Currency"->"No LOCATION"->"No Property"->"No Job"->"No Employee"->"No LINE_OF_BUSINESS"->"BegBalance");
EndIF
)
EndFix
EndFix
Regards,
Sarath