multiplying columns adding rows for a final total

This topic is locked

multiplying columns adding rows for a final total	2/25/2008 6:12:02 PM
PHPRunner General questions
U unimatrix author I'm building an invoice tracking tool where there are single line text fields like this: item# \| Description \| Qty \| Price\| Total I need it to take what is entered into QTY and Price to create a total for each row and then at the end of the form calculate the total. Normally I'd use Javascript for this, but I was looking through the code base and not really sure where to add it. Thanks.


	Alexey admin 2/26/2008
	Hi, add a calculated field on the Edit SQL query tab in PHPRunner to calculate row total. I.e. select item#, description, qty, price, *priceqty as total from ... Then add Page total on the Field order and totals**tab.