11 Replies Latest reply: Oct 26, 2016 2:20 PM by Hirish V RSS

    RE:Seperate column

    Chanty 4u

      Hi all ,

      Sunny T

      I have data like Paid and Received .  tables with the column names  for the month of April ... and i have same paid and recvd for every month .




      Date  ProductName  PaidAmount  



      Date  Productname  RecvdAmount



      so now my requirement is:

      1)  in paid table  having same product transaction is multiple times so i need to sum of the products amount in  Paid and Received tables

      2) and i need create the column   PaidAmount-ReprievedAmount    as summary

      and if     PaidAmount-RecievedAmount    is Negative  display as  Payable 


      if it is positive   display as receivable



      Thanks in advance