6 Replies Latest reply: Oct 12, 2012 1:44 AM by ALEXIS TAN RSS

    Find Cost in Table

      Hi,
      I have data which is given below format and I want to find out deleted and new assets between to months,
      so table rows in red is deleted and in green is new assets in table
      Asset idGroupCostMonth
      12a1008/31/2012
      13a2008/31/2012
      14b3008/31/2012
      15a2008/31/2012
      16b1508/31/2012
      12a1009/30/2012
      13a2009/30/2012
      50b6009/30/2012
      51a7009/30/2012
      16b1509/30/2012
      This is my date selection from list
      Current DateComparision Date
      8/31/20129/30/2012
      Requried out is given below:
      GroupDeleted CostNew Cost
      a200700
      b300600
      Total5001300
      Please let me the expression for above requried output.
      Regards,
      Zain.