2. PHPRunner General questions
  3. Sum all values in a column
This topic is locked

Sum all values in a column

 		1/1/2010 6:55:34 PM
PHPRunner General questions
vin7102 author

Hi,
PHPRunner 5.1,

I have a table ("price_quote") and have a code snippet box under the "sub_total" column on the list page that I would like to show the sum all the values in "sub_total".

Also, is it possible for that value to show on the printer friendly page? If not, how could I achieve that also?
Thanks in advance!

Vince
A
 		alang 1/3/2010

Can't you do this by selecting "TOTAL" for that field on the "Totals" tab?
vin7102 author 1/4/2010



Can't you do this by selecting "TOTAL" for that field on the "Totals" tab?


Hi Alan
Are you talking about getting this total on a report page? I am looking to get this total to be shown on a list page.

Unless I'm missing something, I dont think there is a total option for a list page. Let me know if I'm wrong though!
I appreciate it

Vince
phray 1/4/2010



Hi Alan
Are you talking about getting this total on a report page? I am looking to get this total to be shown on a list page.

Unless I'm missing something, I dont think there is a total option for a list page. Let me know if I'm wrong though!
I appreciate it

Vince


They say a picture is worth a thousand words. And I'm no good with words.
Sergey Kornilov admin 1/4/2010

Proceed to 'Fields order and totals' screen, switch to Printer tab and choose totals type.
vin7102 author 1/4/2010

Alan, Phray, and Sergey,
Thanks guys, I completely overlooked that tab at the bottom.
Vince