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

Conditional Format - a detail field to a summarized field

Received Response
edited Aug 17, 2021 6:04PM in Reporting and Analytics for HCM 1 comment


I have an analysis report where I list all the active positions and their FTE along with the employees assigned to those positions and their FTE. I want to compare the position's FTE to the sum of all the employee's assigned to that position FTE's and format when the employee FTE count is lower than allowed or greater than allowed. For example, the dishwasher position has 10 FTE's, however there are 11 people assigned to this position, all with 1 FTE. Color formatting the FTE would be RED because there are more FTE's assigned to the position than what is allowed.

Any ideas on how to format a sum of a column to a record column?


Howdy, Stranger!

Log In

To view full details, sign in.


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