Set expression- date

[shamitshah]

Hi,

I have the following two expressions. The first one works , but the second one does not.

sum(if(DueDate>Today(), OrderedUnits))

AGGR(SUM({<DueDate={">today()"}>}OrderedUnits),[Item Number])

Appreciate your help.

Shamit

[tamilarasu · Accepted solution]

Hi Shamit,

Try,

AGGR(SUM({<DueDate={">$(=today())"}>}OrderedUnits),[Item Number])

[susovan]

Hi Shamit,

Try this,

=AGGR(SUM({<DueDate={">=$(=Today())"}>}OrderedUnits),[Item Number])

[sujeetsingh]

AGGR(SUM({<DueDate={">$(=today())"}>}OrderedUnits),[Item Number])

[lalitkgehlot89]

Hi Shamit,

Please try like this.

=aggr(sum({<duedate={">$(=today())"}>}OrderUnits),[Item Number])

[shamitshah]

Thanks!

Shamit