Group Calculation

[Anonymous]

In this table I am having trouble trying to calculate the Day 01 Weight column. If I select a certain group code it gives me the correct amount, but I need the table to give the correct amount by Group Cd without having to select one. Any help on this will be greatly appreciated. 

[JonnyPoole · Accepted solution]

hi there i downlowed your qvw and tried this. Does it work ?

Sum(Total <Project_#> fDay1_wt * Aggr(Sum(Head_Start), fDay1_wt,Project_#))

/

Sum(Total <Project_#> Aggr(Sum(Head_Start), fDay1_wt,Project_#))

[Anonymous]

Awesome job, thank you.