This content has been marked as final. Show 4 replies
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