set expression

[#1]

REC_DAT <= monthend & GR_DAT = “ NULL” or > monthend

i need the set expression for the above logic

REC_DAT and GR_DAT are the fields that contains date(DD-MM-YYYY)

[jagan]

Hi,

Try like this

=Sum({<REC_DAT ={'<=$(=MonthEnd(Today()))'}, GR_DAT -={'*'} + {'>$(=MonthEnd(Today()))'}>} MeasureName)

Replace Today() with your required date, and MeasureName with your measure name.

Regards,

Jagan.

[#3]

Hi Bhanu , Please find the below expression.

{<REC_DAT ={"<=monthend"},GR_DAT={""}>}

[#4]

hi

=Sum({<REC_DAT ={'<=$(=MonthEnd(fyear()))'}, GR_DAT ={'*'} + {'>$(=MonthEnd(fyear()))'}>} INV_QTY)

tried this but showing wrong values

=Sum({<REC_DAT ={'<=$(=MonthEnd(fyear()))'}, GR_DAT -={'*'} + {'>$(=MonthEnd(fyear()))'}>} INV_QTY)

and this is showing 0 for all the month fields

fyear is my fiscal year

[its_anandrjs]

Try this way also

=Sum({<REC_DAT ={'<=$(=MonthEnd(YourDateField))'}, GR_DAT ={ '' } + {'>$(=MonthEnd(YourDateField))'}>}

Or

=Sum({<REC_DAT ={'<=$(=MonthEnd(Today()))'}, GR_DAT ={ '' } + {'>$(=MonthEnd(Today()))'}>}

Note:- Compare the REC_DAT and GR_DAT with any Your Date field

[#6]

hi all

none are working actually and i am attaching the fields of both 'recdate' and 'gr date'  and sum is to be done to INV_QTY field....could you please check whether the condtion works or not and if it works the ans is 0 or any number

[sasikanth]

HI Bhanu

try some thing like this

sum(if(REC_DAT<MonthEnd(Today()) and GR_DAT='' or GR_DAT>MonthEnd(Today()) , INV_QTY))

[jagan]

Hi,

What is the monthend value in your expression?  Is it current MonthEnd? or any other logic?

Regards,

jagan.

[jagan]

Hi,

You have data only till March-2014, then what is the monthend value?

Regards,

Jagan.

[jagan]

Hi,

This expression is working but you do not have data for this expression

=Sum({<REC_DAT ={'<=$(=MonthEnd(Today()))'}, GR_DAT = (GR_DAT - {"*"}) + {'>$(=MonthEnd(Today()))'}>} INV_QTY )

Regards,

Jagan.