Percentage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have these captions on the Report footer First Text Box: =Count([Y/N]) gives me a total of "Y/N" Second text box:=Abs(Sum([Y/N]="N")) gives me a total of only "N" Here is the questions, how can I divide "N" by "Y/N" to get a percentage?I used a text box with =Sum([Y/N]="N")/([Y/N]), but it doesn't work. Any help, thanks!
 
Hi.
I'll assume that the first textbox is name "CountAll" and
the second is "CountYes", and that these two texboxes are
in the report footer.
Than you can create a third textbox and you can set the
control source to
=[CountYes]/[CountAll]
Set the format for this textbox to percent and it will do
just what you want.
Hope this helps.
Fons
-----Original Message-----
I have these captions on the Report footer First Text
Click to expand...
Box: =Count([Y/N]) gives me a total of "Y/N" Second text
box:=Abs(Sum([Y/N]="N")) gives me a total of only "N" Here
is the questions, how can I divide "N" by "Y/N" to get a
percentage?I used a text box with =Sum([Y/N]="N")/([Y/N]),
but it doesn't work. Any help, thanks!
 
Back
Top