Custom COUNT / TOTAL / AVERAGE ?

This topic is locked

Custom COUNT / TOTAL / AVERAGE ?	2/7/2012 9:29:47 AM
PHPRunner General questions
milsimcorps author PHPRunner6.0 (Build 9948) - I have a column that has "Yes", "No" and "na" values. I need to COUNT (or TOTAL ??? ) only the "Yes" values from the column in the "List page". If I use COUNT from the "Fields order and totals" section of PHPRunner, I get a count of all of the values (including "No" and "na"), which isn't what I need. How do I get a count of only the "Yes" values? Is it through the Editor section or maybe the Events section? Do I need to write some code somewhere? I couldn't find steps that work in the documentation nor in the forum. Thank you in advance.


	kujox 3/3/2012
	PHPRunner6.0 (Build 9948) - I have a column that has "Yes", "No" and "na" values. I need to COUNT (or TOTAL ??? ) only the "Yes" values from the column in the "List page". If I use COUNT from the "Fields order and totals" section of PHPRunner, I get a count of all of the values (including "No" and "na"), which isn't what I need. How do I get a count of only the "Yes" values? Is it through the Editor section or maybe the Events section? Do I need to write some code somewhere? I couldn't find steps that work in the documentation nor in the forum. Thank you in advance. You'll have to put in WHERE column='yes' in the sub table I believe, without looking I'm not sure which bit you'd put it in.