set analysis and expression

[krishna20]

Hi friends

I need  to include set analysis inside the expression please any one can help me out.

my expression is =SUM({<CE_CLOSE_YN={'1'},{<CE_CLOSE_DT<TODAY()>}>}CE_AMT_LC1=0) and in else condition CE_CLOSE_YN>='1' and CE_CLOSE_DT>Today(),SUm(CE_AMT_LC_1)

Regards

kalyan

[sasikanth]

hi

try some thing like this

if(sum({<CE_CLOSE_YN={'1'},CE_CLOSE_DT={"<(=TODAY())"}>}CE_AMT_LC1)='0',

sum({<CE_CLOSE_YN>={'1'},CE_CLOSE_DT= {">(=Today())"}>}CE_AMT_LC_1))

[krishna20]

Hi Sasi

The expression is raising error .not at all taking from after closing set analysis.

[sasikanth]

Try

IF(isNull(sum({<CE_CLOSE_YN={'1'},CE_CLOSE_DT={"<(=TODAY())"}>}CE_AMT_LC1)),

sum({<CE_CLOSE_YN>={'1'},CE_CLOSE_DT={">(=Today())"}>}CE_AMT_LC_1))

[Anonymous]

Hi,

Try below,

Sum({<CE_CLOSE_YN={'1'},CE_CLOSE_DT={"<(=TODAY())"}>}CE_AMT_LC1)+

Sum({<CE_CLOSE_YN-={'1'},CE_CLOSE_DT={">=(=TODAY())"}>}CE_AMT_LC_1)

[#6]

hi

try like this

Create variable like

Vsum=sum({<CE_CLOSE_YN={'1'},CE_CLOSE_DT={'<$(=Date(today(),'DD/MM/YYYY'))'}>}CE_AMT_LC1)

Vsum1=sum({<CE_CLOSE_YN>={'1'},CE_CLOSE_DT= {">(=date(Today(),'DD/MM/YYYY'))"}>}CE_AMT_LC_1)

then try to build the expression like

=if(Vsum='0',Vsum1)

hope this will helps you