0

Count new customers

Jet Reports Historic Posts

September 30, 2010 07:28

None

Follow

Hi,

I am trying to count the amount of new customers that received an invoice in the last month of a certain period, but who haven't received in invoice before this period.
I am trying to create a formula using the "Cust. ledger entry" Table, but I am not able to implement the filter which exclude all customers who received an invoice before the date filter. Can anybody help me?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts September 30, 2010 14:30

  Try creating two filters on Cust ledger entry one with date prior second with posting period you want
  
  So first date range is beginning of time to start date of period
  second date range is Beginningh of time to end of period
  
  NL( "filter", Cust ledger entry , No. , posting date , first date range)
  NL ( Filter, Cust Ledger entry, "No., posting date . second date range
  
  NP(Difference, Filter 1, filter 2) this will give you the new ones
  
  Filter Cust master on whether in the NP Difference cell )