AnsweredAssumed Answered

Calculation 2 fields in 2 different table - How

Question asked by mayor on Dec 2, 2008
Latest reply on Jan 5, 2009 by TSGal

Title

Calculation 2 fields in 2 different table - How

Post

I got 2 table, vot & expenses.

 

vot (vot_no, current_amount, vot_balance)

expenses (invoice_amount, invoice_date)

 

The formula is :

vot_balance = current_amount - invoice_amount

 

When I make the calculation, question mark (?) is displayed, not the amount expected.

Please, guide me.

 

TQ

 

Outcomes