I'm stuck on this formula =NL("Sum";"Item Ledger Entry";"Cost Posted to G/L";"Posting Date";$D$4;"Inv. Post. Group (Val. Ledger)";"DELER";"Item No.";G$17;"Location Code";$D$8;"Avdelingskode";$D$6;"Item No.";$D$9), which gives out the same input on all lines. I need it to putray the sum for item no. and location code on one line each.
Date
Votes
1 comment
-
Bryan Robinson Best guess is that this is happening due to locked cell references and duplicate filters. I see you have two filters for Item No., one is pointing at G$17 and the other at $D$9. Remove the one that is the incorrect reference.
I would also guess, but can't know for sure that G$17 shouldn't have row 17 locked. Otherwise as you copy it down, it would always look at row 17 but without seeing the whole report, this is just speculation.
Please sign in to leave a comment.