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

How to get highest value from 4 different columns for each person

Accepted answer
51
Views
6
Comments

Summary:

I am trying to retrieve the highest value from 4 fields for each person

For example these four people have various values in the 4 columns (some are null)

The results I need are just showing the highest value for the 4 columns

Also, I need to exclude any columns that may be blank.

I am using the "Workforce Profiles - Person Profile Real Time" Subject Area to get this calculation but also I am using

"Workforce Management - Worker Assignment Real Time" and "Workforce Management - Person Real Time"

Is there a way of producing this information?

My current xml is attached.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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