Changing Status Between Period.

[ch_riadh]

Hi

Sales Table:

SalesID,

Month (Oct, Nov)

Status (Invoiced, Sold, Delivered)

I want to display and count the SalesID who have been invoiced or Sold in 'Oct' and Delivered in 'Nov',

the Salesid who change to Delivered in Oct.

count({<Month={'Oct'},Status-={'Delivered'}>}SalesId) ------> not delivered in Oct.

count({<Month={'Nov'},Status={'Delivered'}>}SalesId) ------> Delivered in Nov.

not delivered in Oct. -  Delivered in Nov   -------> will give me all the SalesID.

But I need only the SalesID Del in Nov and not in Oct.

I need the display only SalesID 2 and 3.

Thanks

[kaushiknsolanki]

Hi try this,

count({<SalesId= p({<Month={'Oct'},Status-={'Delivered'}>}),Month = {"Nov"},Status = {"Delivered"} >}SalesId)

Regards,

Kaushik Solanki