Calculations in a report

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.
 
K

Klatuu

If I understand your question correctly, you want to subtract the total score
from 100, then it would be:
=100 - Sum([CountScore1]+[CountScore3]+[CountScore10])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top