Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Calculation Value Definitions Not working For Range Value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculation Value Definitions Not working For Range Value

Received Response
12
Views
4
Comments
edited Jul 13, 2021 8:39AM in Payroll and Global Payroll Interface (GPI) 4 comments

Content

We have requirement to deduct Tax based on Regular Salary . If the YTD regular Salary amount is less than 400,000 then it should deduct   1.4% of current run regular salary. If Balance is more than 400,000 than deduction amount % should be 2.4%. 

We defined Calculation Value Definitions with Flat amount and added to element calculation factor but deduction amount is always based on first line of Calculation Value Definitions . which is 1.4%.

Calculation  Type - Flat Amount

Basis of Calculation Value - REGULAR_SALARY_ASG_YTD

Calculation Values

0-399,999   - 1.4

400,000 - 999,999 - 2.4

Could you please suggest 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!