General information
Category:
Coding, syntax & commands
COUNT FOR score1 = 'P' and score2 = 'P' and score3 = 'P' to somecount
pctpass = somecount/reccount()
pctfail = (reccount() - somecount)/reccount()
>Hi All,
>
>I have one table with the following fields:
>
>SCORE.DBF
>
>ID# SCORE1 SCORE2 SCORE3
>
>11111 F P P
>22222 P P P
>33333 P F P
>44444 F F P
>55555 P P P
>
>F = FAIL
>P = PASS
>
>How to get the report which shows the result like this :
>
>Scan to each record and if F(FAIL) is detected then does not
>count that record at all for the calculation of percentage.
>This means only ID# 22222 and ID# 55555 should be counted
>2 records out of 5 have passed ( all P for score1,score2,score3)
>
>and to have a second REPORT.DBF with two fields :
>
>PASS/FAIL TOTALREC
>
>2 Passes 5
>3 Fails 5
>
>and finally the report :
>
>REPORT.FRM ( SCORE REPORT )
>
>PERCENT PASSED 2/5 = 40%
>PERCENT FAIL 3/5 = 60%
>
>Any kind of source coding would be greatly appreciated ?
>
>Thanks in advance,
>Paul
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only