Skip to Content
Former Member
Jun 15, 2016 at 05:30 PM

Query - Sales


Hi Experts,

Has anyone created a Query for Previous Day Sales and Month To Date Sales? One condition is not to include the weekends when the previous day sales are generated. Ex: if the report is generated for Monday, the previous day sales figures should come from Friday and not Sunday. Below is how the query should look,like:

Salesperson Sales prev day GM% Sales MTD GM% Employee A $1,485.65 28.40% $16,637.83 30.87% Employee B $1,897.50 29.58% $41,898.53 32.06%

Thanks in Advance,