is it group by?

[krithikarees]

Hi ,

I am trying to combine all the period fields to show the total budget amount in the script but not sure how to do it. 

[IamAlbinAntony]

Try aggregation of sum with group by,

Load 

sum(budg_mt) as total

resident table

group by

FiscYear, ...(rest of the fields)

;