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 .

       

       

      PaidTable:

      Date  ProductName  PaidAmount  

       

      ReceivedTable:

      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