Combine Set expression

[vchuprina]

Hi All,

I have following expression:

$(vTotalOrder)

sum(OrderLA)

______________________

$(vShipped)

sum(
{$ <[Order Status]*={'*1', '1*'},
[Code]*=-{'To'}>
} OrderDA )

______________________

$(vCalcOrder)

=$( vTotalOrder)-$( vShipped)

______________________

$(vOrderInBack)

sum(
{$ <
[Order Status]={'>=01<=12'},
[Code]=-{‘To’},
[$(=DateF) Date]*={'<$(vCalcDate)'}
>}
(OrderLA-OrderIA))

I need to know how many OrderInBack in vCalcOrder.

How can I combine those set expressions?

[MK_QSL]

Provide few lines of sample data or sample app to work along with your expected output.

[vchuprina]

  Hi Manish

Div	vTotalOrder	vOrderInBack	vShipped	vCalcOrder
	76 289 943,85	108 942,16	-91 983,82	76 381 927,67
100	12 576 242,85	6 355,08	-58 056,79	12 634 299,64
200	63 713 701,00	102 587,08	-33 927,03	63 747 628,03

Order Status

1

23

42

Code

To

For

Rec