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

Visit Redwood Community
Latest Tax not Pulling through Subquery Results — 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

Latest Tax not Pulling through Subquery Results

Received Response
2
Views
1
Comments
edited Oct 19, 2022 12:41PM in Reporting and Analytics for HCM 1 comment

Summary:

Latest Tax not Pulling through Subquery Results

Content (required):

The sub query set up correctly pulls back latest tax code effective start date in a calculated column as below:

MAX("Calculation Component Details"."Calculation Component Details Effective Start Date" BY "Worker"."Person Number")

The sub query report also includes the Person Number, First Name and Last Name from the Payroll - Calculation Cards Real Time subject area.

However there is a another report that I've linked to the sub query via Person Number and the calculated Latest Tax Start Date columns which includes the Tax Code , Tax Basis as well as Person Number, First Name, Last Name and Effective Start Date, but this is bringing back all the tax codes an employee has had. This report uses the same subject areas.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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