2. PHPRunner General questions
  3. [SOLVED]  How to multiply two columns of report and display in new column
This topic is locked
[SOLVED]

 How to multiply two columns of report and display in new column

 		10/21/2012 5:25:25 PM
PHPRunner General questions
T
 Tayyab Ilyas author

Can anyone help one below
I have two columns in report

Total Draw and Complaints coming from query

I wants add a new column in report displaying Total Draw Multiply Complaints


Second Question
Same formula i wants to apply on summery variables i.e Sum of total draw multiply by sum of total complaints
I have attached a snapshot to explain batter
Admin 10/21/2012

The best option to do that right in SQL Query i.e.

select

field1,

field2,

field1*field2 as NewField

From tablename
T
 		Tayyab Ilyas author 10/22/2012

Thanks Dear

It works great.

My second question: How can i multiply total values for both column what are generated by report summary.

Thanks for your support