2. PHPRunner General questions
  3. Calculating yes and no
This topic is locked

Calculating yes and no

 		2/6/2008 7:20:08 PM
PHPRunner General questions
J
 jamesberry12 author

I have a field whose value is either Yes or No I would like to calculate the percents of Yes on the bottom of the list fields.

Suggestions?
J
 		Jane 2/7/2008

Hi,
you can do it using custom event on the Visual Editor tab (Insert PHP code snippet option).
J
 		jamesberry12 author 2/8/2008

Hi,

you can do it using custom event on the Visual Editor tab (Insert PHP code snippet option).


like this?

select

...

Sum(Yes)/Sum(No)*100 as Percent,

...

from TableName