1 Reply Latest reply: Jan 22, 2013 3:20 AM by Rob Wunderlich RSS

    Need help on  Reports based on two different dates

    Tushar Suvarna

      Hi

      I Have a simple report to be generated ie

      Due vs Collection for each month   . 

       

      The fields are   Due_date, Due_amount, Paid_date, Paid_amount  in the table now i take due_date as a dimension and  put expression  as sum for due amount     and paid amount  .

       

      The Due Amount sums up correct but the paid amount is incorrect for the given month .

       

      I Have attached a sample application with  Payments table and a master calender  and the data for payments is for months april-2012  

       

      I want the logic to include total dues  and total collection for a month ..

       

      Can anyone help me out with this

       

      Thanks in advance ,

       

      s_tushar