Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is wrong with the expression(aggr is wrong):
sum({<inpdate={'<=$(=date($(saldate)))
>=aggr(min({<inpdate={'<=$(=date($(enddate)))>=$(=date($(startdate)))'}>}inpdate),SERIALNO)
'}>} SALES)
the third get the min date by serialno
Can you share your file here.
Jagan,
sorry, but are you sure, that this part:
$(=Min({<NumINPDATE={">=$(vStart)<=$(vEnd)"}>}INPDATE))
will give result regarding dimension value?
if I change startdate to 2013/01/18,B should be 14 not 20.
Dariusz Mielczarek,
Please check my attachments in above conversation, It matches the output result what Jack he is expecting. Let me know if you have any queries.
Thanks,
Jagan
yes. this date is ok. like the date for B is 2013/01/30
Ok, i will if i only get new license
look:
$(=Min({<NumINPDATE={">=$(vStart)<=$(vEnd)"}>}INPDATE))
$(= )
In my oppinion it will give only one date point for entire SERNO poppulation. But Jack needs here 1 date for each SERNO....
Because each of SERNO may have different min INPDATE between start and end date
yes ,I should get the min date for each SERNO. I hope to use aggr ,but It don't work.
I have to go home now.
If there will be still no solution, i will try to do something more with this subject today evening (we have 17:00 now).
regards
Darek
Try this
=Sum({<SALDATE={'>=$(=Min({<INPDATE={">=$(vStart)<=$(vEnd)"}>}INPDATE))<=$(vSaleDate)'}>}SALQTY)