How to Sum a column if two tables have one to many relationship?

[Anonymous]

I have attached sample file. please help me to sum by grouping ..

[avinashelite]

Try this

Aggr(sum(DivisionProcedureCNT),CPT)

[Anonymous]

Nope, It does not work.

[aarkay29 · Accepted solution]

May be this:

sum(aggr(DivisionProcedureCNT,YearMonthNBR,CPT,VisitTypeCD,DivisionNM))

[Anonymous]

I think this works. Thank you very much. That was easy I guess! I did not try that before!