Hello
I have created a form with the fields of the table and i am calculating the EarnedSalary and EarnedAllowance based on the workingDays.Its working fine if i enter workingDays any value.
Now my Question is If an employee is not present for the whole month then Working Days=0 and the final Value of the Gross Salary and Total Deductions should be populated to 0.But i am getting a value in this because of the fixed HRA and transport .Now i want to make GrossSalary and Total Deductions to 0 if WorkingDays=0.
How can i write an IIF statement and where i should wirte ?
Can anybody please help me out.....
I have created a form with the fields of the table and i am calculating the EarnedSalary and EarnedAllowance based on the workingDays.Its working fine if i enter workingDays any value.
Now my Question is If an employee is not present for the whole month then Working Days=0 and the final Value of the Gross Salary and Total Deductions should be populated to 0.But i am getting a value in this because of the fixed HRA and transport .Now i want to make GrossSalary and Total Deductions to 0 if WorkingDays=0.
How can i write an IIF statement and where i should wirte ?
Can anybody please help me out.....