Creating a formula based on valid cases

  • Thread starter Thread starter Wilks
  • Start date Start date
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"
 
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...
 
Back
Top