Hi,
I am trying to create a if, then function in a derived field. I am using ADP PC Payroll 4.5 and Reportsmith 4.2 SQL database. The field keeps returning "Not enough operands". The field is below:
@IF(REPORTS.V_EMPLOYEE.ANNUALSALARY/12>8333,8333,REPORTS.V_EMPLOYEE.ANNUALSALARY/12)
What am I doing wrong?
I am trying to create a if, then function in a derived field. I am using ADP PC Payroll 4.5 and Reportsmith 4.2 SQL database. The field keeps returning "Not enough operands". The field is below:
@IF(REPORTS.V_EMPLOYEE.ANNUALSALARY/12>8333,8333,REPORTS.V_EMPLOYEE.ANNUALSALARY/12)
What am I doing wrong?