expression with set analysis

[adiarnon]

hi,

i have an expression -

SUM({<PO_DUE_DATE=>{today()}>}PO_QUANT)

whats wrong?

tnx

[MK_QSL · Accepted solution]

SUM({<PO_DUE_DATE={'>$(=Today())'}>}PO_QUANT)

[its_anandrjs]

Check your date format and use like

SUM({<PO_DUE_DATE={">$(=Today())"}>}PO_QUANT)

[adiarnon]

tnx,

can i do set analysis on a concat function?

like-

Concat({<PO_DUE_DATE={'>$(=Today())'}>}[PO_num],', ')

[MK_QSL]

Yes

Concat({$<PO_DUE_Date = {'>$(=Today())'}>}[PO_num]

UPDATE : Check enclosed file..