0

Sales For Newly Created Customers

Jet Reports Historic Posts

September 03, 2014 09:52

None

Follow

Good morning,

I am currently attempting to pulls sales from a Transaction Table with all customers accounts created after a particular time. The formula I am using does not seem to giving the desired results. It seems to be ignoring the Date Created field as a parameter. Can anyone help: -

Below is the formula I am using

=+NL("Sum","Transaction","Net Amount","Date","18/08/2014","Store No.","S037","Price Type","<>REDEEM","Link=","Customer","No.","=Customer No.","Date Created","01/08/14..")

D.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 05, 2014 14:13

  I think the problem is the Date Filter on your customer creation date, it should have and end date. use a NF function to create a date filter using a =Today() as the end date. this should be done in the Options tab if you are using it. please see the attached draft

  • Cust Sales.xlsx
• 0
  
  Jet Reports Historic Posts September 10, 2014 13:13

  Thank you. I'll see let you know if it works. :D