Hi everyone,
I would like to know what would be the best way to isolate a value that appear in all the lines.
I am working on a freight cost report to have SOPackageDetail in its relation. When I add the table, my DocAmt and FreightCost repeat itself based on the number of line in SOPackage,LineNbr. I try to use below formula to filter out but not successful:
=IIF([SOPackageDetail.LineNbr]<>first(SOPackageDetail.LineNbr),0,[ARInvoice.OrigDocAmt])
=IIF([SOPackageDetail.LineNbr]<>Last(SOPackageDetail.LineNbr),0,[ARInvoice.OrigDocAmt])
=IIF([SOPackageDetail.LineNbr]<>MAX(SOPackageDetail.LineNbr),0,[ARInvoice.OrigDocAmt])
These formula work with most cases but there are shipments that does not start with line 1 and value could not be shown. See below screen shot for reference:
I have attached the file for reference. Hopefully someone would be provide insights or directions on how this can be done.
Kind regards,
Calvin
Best answer by BenjaminCrisman
View original