Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Shamit,
Try,
AGGR(SUM({<DueDate={">$(=today())"}>}OrderedUnits),[Item Number])
Hi Shamit,
Try,
AGGR(SUM({<DueDate={">$(=today())"}>}OrderedUnits),[Item Number])
Hi Shamit,
Try this,
=AGGR(SUM({<DueDate={">=$(=Today())"}>}OrderedUnits),[Item Number])
AGGR(SUM({<DueDate={">$(=today())"}>}OrderedUnits),[Item Number])
Hi Shamit,
Please try like this.
=aggr(sum({<duedate={">$(=today())"}>}OrderUnits),[Item Number])
Thanks!
Shamit