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


      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 ,