Crosstab isnull?NZ?

  • Thread starter Thread starter Maxwellll
  • Start date Start date
M

Maxwellll

Here is the issue in the crosstab query.

I have Item UPC going down, Timeline going across, sales
as value.

In some cases when there are no sales for that item in
that timeline (i.e. Apples had no sales in May of week 2)
the cell for the value section comes out blank.

I want the cell to show a zero if it is blank for
calculating purposes later on. How do I force a zero if
the cell comes out blank?

Please help!!!
 
Switch the crosstab query to SQL View (View menu).

You will see something like:
TRANSFORM Sum(Orders.QtySold) AS SumOfQtySold ...

Insert the Nz() around that expression:
TRANSFORM Nz(Sum(Orders.QtySold),0) AS SumOfQtySold
 
Back
Top