Calculations in a report

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I have the following calculation in the control source.

=Sum([CountScore1]+[CountScore3]+[CountScore10])

How do I get the total scores (i.e. 4) minus this score from 100.
 
If I understand your question correctly, you want to subtract the total score
from 100, then it would be:
=100 - Sum([CountScore1]+[CountScore3]+[CountScore10])
 
Back
Top