Sum of run result value give the YTD value

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