Dear All,
I have to calculate simulation of salary i.e. salary of all the employees selected by user should be deducted from the salary amount of all employess.
For which first i would have to calculate salary of all employess which will not change on any employee selections.
For these i can by-pass employee field in set analysis expression,but the employee code which iam getting is through some other expression.
So now how to by-pass an expression in a set analysis expression.
Following is my normal Set Expression where Employee feild is by-passed
"num(((sum({1} {<EMPLOYEE_Code=,
EMPLSTATUS = {3},FinYear = {"$(vMaxFinYear)"},Year_Month_new = {"$(vMaxMonthName)"},PAYRL_AREA -= {00},EMPLGROUP -= {9}>}ANSALARY))*VCurrency_INR)/vUnitSelector,'#,##,###.##') "
now the expression which is to be bypassed instead of Employee_Code field is
"if(FinYear = vMaxFinYear and Year_Month_new = vMaxMonthName and EMPLSTATUS = 3 and PAYRL_AREA <> 00 and EMPLGROUP <> 9 and Function_Text = GetFieldSelections(Function_Text), EMPLOYEE_Code) "
Regards,
Sumit
