Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one explain set analysis behind this variable
$(vReqShipQtyToMonthEnd)
sum({$<ReqShipDateNum_OO={">$(=vCurrentDateNum) <$(=vMonthEndNum)"}, %ShipDate=, %ShipDateMonth=,
%ShipDateYear=, %ShipDateDay=, %CancelDate=, %CancelDateDay=, %CancelDateMonth=, %CancelDateYear=,
OrderDate_OO=, OrderDateDay_OO=, OrderDateMonth_OO=, OrderDateYear_OO= >} Quantity_OO)
Specially why they are using all this fled names in above calculations
%ShipDate=, %ShipDateMonth=,%ShipDateYear=, %ShipDateDay=, %CancelDate=, %CancelDateDay=,%CancelDateMonth=,%CancelDateYear=,
OrderDate_OO=, OrderDateDay_OO=, OrderDateMonth_OO=, OrderDateYear_OO=
This seems to be Summing Quantity_OO between the dates vCurrentDateNum and vMonthEndNum. The rest of the calendar fields are ignored so that the expression is not filtered based on selection in any of those fields. So in short this expression will be only based on a range of ReqShipDateNum_OO
It is doing SUM on Quantity_OO
Where ReqShipDateNum_OO is >=vCurrentDateNum AND < vMonthEndNum
They are using all other fields to ignore the selections of those respective fields if any,
This seems to be Summing Quantity_OO between the dates vCurrentDateNum and vMonthEndNum. The rest of the calendar fields are ignored so that the expression is not filtered based on selection in any of those fields. So in short this expression will be only based on a range of ReqShipDateNum_OO