0

is using two NL row functions in one sheet possible?

Jet Reports Historic Posts

May 01, 2014 08:51

None

Follow

Hello,

Im new here and also new in using jet. Im trying to make an overview of the difference between incoming and outgoing cash.
So, i used nl row customer ledger entry and nl row vendor ledger entry.

When i run this report i see that the rows of customer ledger entry are not unique the variables are reported multiple times. I guess this is because of the vendor ledger entry, there are more unique records and so the rows of customer ledger entry are influenced by these.

Is there any possibility to report only the unique records of both?

• jet community.xlsx

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts May 02, 2014 18:18

  Try to have your first NL row on customer ledger Entry on line 6 and nl row vendor ledger entry on another line (ie : lige 10 this could give you some spacing to insert a TOTAL via an Excel =SUM function for each NL(Row) )

• 0
  
  Jet Reports Historic Posts May 05, 2014 08:29

  Try to have your first NL row on customer ledger Entry on line 6 and nl row vendor ledger entry on another line (ie : lige 10 this could give you some spacing to insert a TOTAL via an Excel =SUM function for each NL(Row) )

  
  It works. Thank you.
• 0
  
  Jet Reports Historic Posts May 06, 2014 17:10

  As your Jet skills progress, you'll use multiple rows functions often. One of the primary uses is to nest them. For example, the first Rows will pull all the Sales Invoices, and the second Rows will pull all the Sales Invoice Lines for each Invoice.
  
  Another example would be using a Columns function paired with a Row function. Imagine a set of item numbers in the Columns function, and then Customers or Sales Orders in the Rows going down.