Subtracting two fields from two different tables

[Karahs]

Hello Community,

Can we subtract two different fields from two different tables?

For eg.  Unit Price and Quanity are in one table AND Cr_Unit_Price and Cr_Quantity are in another table,

             I need to calculate Sum(Unit Price * Quantity) - Sum(Cr_Unit_Price*Cr_Quantity)

I am getting no result, can anyone give any solution for this?

Thanks in advance

[sunny_talwar]

Are they linked in anyway?

[Karahs]

Yes they are linked with Document No.

[sunny_talwar]

Then I think you should be able to do it... Is it not working?

[rittermd]

When I have had to do something like this in the past I joined the 2 tables into a single table.  Then followed that with a resident load step of that single table and did my calculation in this step.