We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Sum of run result value give the YTD value

Received Response
14
Views
7
Comments

Summary:

Hi All,

Can sum of run result value give the YTD Value?

I tried with the below code but it returns the run result value of the last run.

Any input would be much appreciated.

Thanks.

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Select distinct

 person_number

,

(SELECT 

sum(prrv.result_value)

FROM pay_run_results   prr

,pay_run_result_values  prrv

,pay_element_types_f   petf

,pay_input_values_f    pivf

,pay_ele_classifications_vl pec

,pay_payroll_rel_actions pra_Inner

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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