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?
