What is the syntax for % of Grand Total formula in an Access Grouped Report

emmorel

New member
Local time
Today, 00:00
Joined
May 9, 2016
Messages
8
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]))
 

Attachments

  • Access Report % Grand Totals.jpg
    Access Report % Grand Totals.jpg
    82.7 KB · Views: 105
Last edited:

Users who are viewing this thread

Back
Top Bottom