Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Provide few lines of sample data or sample app to work along with your expected output.
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