I have the following Access report:
Status Expected Actual % of Expected % of Total Expected
Completed 2,552,068 531,061 21.06% (531,061/2787,154) syntax?
In Progress 235,086 44,205 18.80%
(Status footer)
Grand Total 2,787,154 575,266
(Report footer)
The formula for % expected = Sum([Actual])/Sum([Expected])
I tried the following for % of Total Expected but got an error “cannot have aggregate function in expression”
= Sum(Sum[Actual]))/Sum(Sum([Expected]))
Status Expected Actual % of Expected % of Total Expected
Completed 2,552,068 531,061 21.06% (531,061/2787,154) syntax?
In Progress 235,086 44,205 18.80%
(Status footer)
Grand Total 2,787,154 575,266
(Report footer)
The formula for % expected = Sum([Actual])/Sum([Expected])
I tried the following for % of Total Expected but got an error “cannot have aggregate function in expression”
= Sum(Sum[Actual]))/Sum(Sum([Expected]))
Attachments
Last edited: