Changing Status Between Period.

ch_riadh — Mon, 13 Feb 2017 10:33:36 GMT

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

Re: Changing Status Between Period.

kaushiknsolanki — Mon, 13 Feb 2017 10:42:25 GMT

Hi try this,

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

Regards,

Kaushik Solanki