Set expression

[#1]

Fields:

REC_DAT             Received Date

WERKS                  Plant

MATNR                Material Number

INV_QTY              Invoice Quantity – 3PL qty

PCN_DAT            PCN date

GR_DAT               GR Date

Logic

For 3PL stock as on 30.04.2014

REC_DAT <= monthend & GR_DAT = “ ” or > monthend this is the logic that i should calculate for all the monthend value to get the 3pl stock

({<REC_DAT= {"<=$(=MonthEnd(Today()))"}, [GR Date]= {">$(=MonthEnd(Today()))", ''}>}

I tried the above expression but it doesnt work

[tresesco]

=sum({<REC_DAT= {"<=$(=MonthEnd(Today()))"}, GR_DAT= {">$(=MonthEnd(Today()))"}>} INV_QTY)

Works. Note, in your sample qvw you would get zero as the GR_DAT condition fails. Try with full data.

[ali_hijazi]

if you change the date format on your PC it won't work

[#4]

what if the condition for GR_DAT can be null and monthend can i have the expression for both the condition that can be null and >monthend

another query whether the above expression provides only for my current month or it provides for all the months