0

Count New Customers

Attempting to count new customers who have an invoice from the cust. ledger entry.  Moving annual total, number of new folks who purchased.

I am  using:

Date 1:

=@NL("Filter","Cust. Ledger Entry","Customer No.","Posting Date",$C$5)

Date 2:

=@NL("Filter","Cust. Ledger Entry","Customer No.","Posting Date",$C$6)

 

Trying to use the NP difference function to count the difference:

=@NP("Difference",C14,C11)

 

Date 1 is ..4/1/2020

Date 2 is ..3/31/2021

Not getting any results,,,ideas?

 

 

 

0 comments

Please sign in to leave a comment.