Skip to Content
0
Former Member
Jul 01, 2009 at 07:49 AM

Particular Columns displaying blank in a Query

156 Views

Hi,

There is a report which helps in determining the Inventory details. For this, We will load data only for Mondays of each week. The columns present in the report are Sold-to-party, Material, Average Mvt for 3 prior weeks, 3 week target, 4 week target, on hand inventory, weeks in inventory, Last week's inventory, Change in inventory, Additional needed for 3 weeks & Additional needed for 4 weeks. The problem is with the columns On hand inventory, Weeks in inventory, Last week's inventory & Change in inventory. For the last 3 mondays alone, there is no data coming up for this columns. For all other mondays data is coming up correctly, only for the last 3 mondays this 4 columns are displaying blank.

I checked with the Formulas of this columns, they look simple & Fine. The formula for Weeks in Inventory is On hand inventory/Avg Mvt for 3 prior weeks. The formula for Change in inventory is On hand inventory-Last week's inventory.

Help me in fixing this.

Thanks,

Murali