Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
U can write script like this
if(TransDate=Aggr(max(Trans_Date), Lot_status),Lot_Status)
if u give sample data, than we can give correct expression.. pls post sample
U can write script like this
if(TransDate=Aggr(max(Trans_Date), Lot_status),Lot_Status)
if u give sample data, than we can give correct expression.. pls post sample
Is working fine now thnks