I need help with a formula to calculate fringe benfits. I need it to do the following, I just can't seem to get the function to work right.
If "gross pay" is < 1056.00 then do nothing. If its > 1056.00 then calculate the gross pay as 1056.
It says remaing text does not seem to be apart of the formula.
if ubound(split({MASTER_PRM_EMPLOYEE.Employee_Name}," ")) >= 2 then
split(split({MASTER_PRM_EMPLOYEE.Employee_Name},";")[2]," ")[1] else
split({MASTER_PRM_EMPLOYEE.Employee_Name},";")[2]
//{@middle}:
if...
We are running Timberline accounting package. Our employee names were enter last, first, M example (doe; John L) I need to plit this field in two three seperate fields. Was is the correct way to do this.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.