I am trying to find away to write a formula that will give me the number of NEW customers in the current months and/or previous months.

my logic was using the invoice created date and company

created is less than the current date and them see if there is an invoice for the company in the other dates.

{Created} > DateTime (2017,10,06) and ({@S2}) <> {Company})

{Created} is Invoice Date
{Company} is Company
{@S2} is a formula that contains {Company}


Edited by gkohut - 12 Oct 2017 at 12:01pm

Dell,

I have it Grouped By Company Then Created.

In theory it is real simple . . .How many new customer in the current month, but I just can't get my head around it to make it happen

So you're looking at all of the invoices in the database to determine whether a client is "new"?

-Dell

This is going to be more easily done using a command (SQL Select statement) instead of linking tables in the report. What type of database are you connecting to? If you would like help with the command, please post the SQL that Crystal has generated for the report.

-Dell

 SELECT `'Hoja_1_'`.`Created`, `'Hoja_1_'`.`Company`, `'Hoja_1_'`.`Total`, `'Hoja_1_'`.`Profit`, `'Hoja_1_'`.`Customer`
 FROM   `'Hoja 1$'` `'Hoja_1_'`
 WHERE  `'Hoja_1_'`.`Customer`<>'gkohut@hotmail.com' AND  NOT (`'Hoja_1_'`.`Company`='Advantek Lighting Inc.' OR `'Hoja_1_'`.`Company`='Lumisolution')
 ORDER BY `'Hoja_1_'`.`Company`