AnsweredAssumed Answered

How to calculate the total of expenses?

Question asked by mayor on Dec 10, 2008
Latest reply on Dec 11, 2008 by mayor

Title

How to calculate the total of expenses?

Post

Hello,

 

I have problem when I try to calculate the total of expenses. I got 2 table as below;

 

Vot(vot_no, vot_amount)

expenses(po_no, po_amount, po_cancel, total_expenses)

 

Let say :

user1 - po_amount is $200

user2 - po_amount is $300

 

I want total_expenses = $500

 

So, what is the formula that i can use to calculate. I have try to use global variable, but when I try to deduct amount from po_cancel, the amount of total_expenses is still same, unchange.

 

TQ

 

 

Outcomes