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:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d44e883e-ece2-4194-9532-209f304d45fc.png)
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