2 Replies Latest reply: Nov 29, 2016 4:27 AM by Vitalii Chupryna

# Combine Set expression

Hi All,

I have following expression:

\$(vTotalOrder)

sum(OrderLA)

______________________

\$(vShipped)

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

______________________

\$(vCalcOrder)

=\$( vTotalOrder)-\$( vShipped)

______________________

\$(vOrderInBack)

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

I need to know how many OrderInBack in vCalcOrder.

How can I combine those set expressions?

• ###### Re: Combine Set expression

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

• ###### Re: Combine Set expression

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