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
edited Oct 19, 2022 12:41PM in Reporting and Analytics for HCM 1 comment


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.


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