Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Newbie Question on Precentages. Post Reply Post New Topic
Author Message
r2ks
Newbie
Newbie


Joined: 29 Jun 2012
Online Status: Offline
Posts: 4
Quote r2ks Replybullet Topic: Newbie Question on Precentages.
     Posted: 29 Jun 2012 at 10:26am
Good Afternoon all,

I have a report with 11 question they are Yes or No answers and what I am trying to do is get only a percentage of "yes" answers.

This answer will then be placed in the Group Footer.

Thank You  
IP IP Logged
Quirky
Newbie
Newbie
Avatar

Joined: 18 Jun 2012
Location: United Kingdom
Online Status: Offline
Posts: 8
Quote Quirky Replybullet Posted: 02 Jul 2012 at 3:59am
You could create a formula to count how many "yes" responses there are:

if AnswerField="Yes" then 1 else 0

You can sum that in the footer and then use it, along with the total number of questions, to get your percentage.

-Q
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.