2 Replies Latest reply: Dec 12, 2012 5:03 AM by Juan Pedro Hidalgo RSS

    Problem with aggregation

    Juan Pedro Hidalgo

      Hey everyone,

      im developing a new report about warehouse's. I have this little problem with an aggregation:

       

      I have a Lot Status Field, this field may change in every line of the Lot Events Table.

       

      The Lot Events Table has a transaction_date field with this format (dd/mm/yyyy hh.mm).

       

      What i want to do is to take the lot status of the last transaction in the table lot events.

       

      I tried Aggr(max(Trans_Date), Lot_status) but is returning -.

       

      Ty for your time

       

      Regards

      Juan Pedro