max unit cost from group

[jobillborf]

Hi I am doing a inventory report and would like to extract the last unit cost from the last tranaction. The items are grouped by part number.

In other words I would like to extract the last unit cost from the max tranactions date.

Thank you

 

[pgtek]

Hi
on your select expert
max(field_name,dateStamp)

hope this help

 

[lbass]

Add a sort by date, descending, and then drag your detail fields into the group header (part numbers) and suppress the details. Then only the most recent unit cost will be displayed.

Another approach is to go to edit selection formula->group and enter:

{table.date} = maximum({table.date},{table.partno})

Then only the most recent dates will appear; however, using the group select means that you will need to use running totals if you will be making calculations, since the records returned by the record select still contribute to calculations though not displayed.

-LB