Creating a formula based on valid cases

W

Wilks

I want to create a formula which would calculate a
percent - but I want to create the formula based on ONLY
those who responded to a question. how do I do this???
For instance - I have a total of 220 records, but only 112
are valid (have responses). I want to calculate only
those who answered Yes or Maybe to this series. The
formula I have right now is below, but it's not working.
Any suggestions?? =Format(DCount
("[q3a]","data061903","[q3a]='Yes' or [q3a]='Maybe'")/
(DCount("[q3a]","data061903")/100),0) & "% Yes or Maybe"
 
T

tina

the rest of the expression i understood, but how does this
work?

(DCount("[q3a]","data061903")/100),0)

looks like you've written a partial function...
 

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

Similar Threads

Automation of scanned file storage based on content 0
Calculating a field based on other fields in a form... 1
IF validation for time totaling 2
Counting Text 1
Need help with Data Validation Formula for a set of numerical andtext-based values 7
Creating a percent of total in a grouping level on a report 2
Creating a macro for a series of questions 0
Need help creating a formula to track % of total responses 2

Top