Unable to use aggregate function in value set — 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

Unable to use aggregate function in value set

edited Jul 22, 2019 12:39PM in Workforce Management 10 comments

Summary

Need to use SUM Function in value set

Content

I have created Value set but i need to use the sum function in it but error out. I think there is some limitation. Please see the below or you guys can suggest DB items.

 

Select a.DURATION  from ANC_PER_ABS_ENTRIES a , PER_ALL_PEOPLE_F P , PER_ALL_ASSIGNMENTS_F F

WHERE a.ABSENCE_TYPE_ID = 300000002435648

AND p.person_id = a.person_id

AND F.person_id = p.person_id

AND F.EMPLOYMENT_CATEGORY = 'PERPM'

AND p.person_id = :{PARAMETER.p_emp_id}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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