Get value of another line in the current line

building reports
1

To clarify best:

image
image2384×189 58.7 KB

I have an Acc Doc with 2 accounts (20000 and 59961) where carriernr and carrier are on both lines the same however for one doc type the field on account 59961 stay empty.
As it is always filled on line with account 20000 I want to build a logic that for the Acc Doc of that line I want to use GL Acc 20000 to derive the Carriernr and Carrier from.

Thing is for the user I only want to show the 59961 line thus it should also work when I filter out the account 20000

2

Something like =NoFilter(Max([Carrier]) in ([Acc Cod])) should do the trick.

3

Thanks @MarkP .
But Max would not work as the carrier was no number and I also needed a field with the carrier name.
However leaving Max out also did the trick. :smiley:

1 Like