Financial calculations

This topic is locked

Financial calculations	8/10/2006 2:17:56 AM
PHPRunner General questions
F fmf author Hi, My client wants to calculate the financial information since he has 3 fileds for each service in the client table. Fields are like this: Design_Required Design_Paid Design_Balance Prog_Required Prog_Paid Prog_Balance My client wants the Balnces to be Required-Paid. What can I type in the default info in PHPRunner to make the client always see the right calculations. Thanks


	Alexey admin 8/10/2006
	Hi, I recommend you to use a calculated field instead of Design_Balance. Modify your SQL query on Edit SQl query tab in PHPRunner this way to add a calcualted field: select ... Design_Required, Design_Paid, Design_Required - Design_Paid as Balance from ...