4 Replies Latest reply: Jun 13, 2017 8:37 AM by Mark Ritter RSS

    Subtracting two fields from two different tables

    Kshitija Shinde

      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?

      aaaa.PNG

      Thanks in advance