How can i do this calculation at the time of loading(with scripting) withiut using variable? help me out

[#1]

Hi Everyone

vart1 = sum{<ancestor_id={'BS020030040010000000000000000000'},str_pov_name={'ACTUAL'}>}money_measure)

here var1 is the calculated value of money measure where ancestor_id={'BS020030040010000000000000000000'} and 

    str_pov_name={'ACTUAL'}   both field are from different table

How can i do this calculation at the time of loading(with scripting) withiut using variable? help me out

[#2]

First of all, If you group by pk_data_details only in your last load, then remove the fields

ancestor_id  and str_coa_code from the load statement. Otherwise you will have to group by all of them:

Group by pk_data_details, ancestor_id, str_coa_code;

[#3]

Hello Quentin

I did that but still script is not loading