I need to condition pay rate in a payroll VI import but I don't know the syntax. Basically, if an earnings code is from S1 to S3, and the payrate1 is less than X then use one formula, otherwise, use another. Here is what I tried.
if {PR.EARN:EARNINGS_CODE} >= "S1" and {PR.EARN:EARNINGS_CODE} <="S3" and {PR.EMPLAY_RATE1} < 25.00 then 25.00 * val({PR.DATAENT:EARNINGS_MULT}) else {PR.EMPLAY_RATE1}*val({PR.DATAENT:EARNINGS_MULT})
Thanks for the help.
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
if {PR.EARN:EARNINGS_CODE} >= "S1" and {PR.EARN:EARNINGS_CODE} <="S3" and {PR.EMPLAY_RATE1} < 25.00 then 25.00 * val({PR.DATAENT:EARNINGS_MULT}) else {PR.EMPLAY_RATE1}*val({PR.DATAENT:EARNINGS_MULT})
Thanks for the help.
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.