Hii all,
I have a problem in which i stuck ..Actually i am printing sum of quantity from table1 using NL(Sum) function and document no.in filter i am using another NL(Rows) function for reference of Document no. from table2 .i am using NL(Rows) bcause multiple document no. is here and i want sum of quantity for all of them..But currently i am getting sum of first document no.
Date
Votes
1 comment
-
Jet Reports Historic Posts Without seeing your report structure - I'm going to guess that the problem is that you aren't including an anchor row in your sum total.
Here is how an anchor row works:
B3 = NL ROWS Command
B4 = BLANK (anchor row)
B5 = Sum Row (which needs to include the anchor row) example: assuming the value you want to total will appear in column D, you would Sum(D3:D4)
What is happening is that the blank row is moving down each time the Rows command inserts a new line, since your sum total on the sum row includes the anchor row - the bottom of your sum command is moving with it.
If your eventual report ends with the last row of the NL Rows in Row 30, your Sum (now in row 32) would be SUM(D3:D31)
The anchor row can be hidden if you want, or if you're like me and want to be able to resort your table after the report runs, you leave it visible and just make it a small font size in all cells on the row.
Please sign in to leave a comment.