I have here a table:
I need to create an analysis, what is the total Qty of the Report Date with the specific date range.
ex: For Report date 20-Sep-14, the range is >=14-SEp-14<=20-Sep-14
How can I include this in my set analysis?
Do have a field which have Dtae=14 Sep 2014 and a Quentity associated with it?
Over gere i guess max(start date) is a calculated field.
Hi, Report date is associated with the Qty. Yes, for example I have to find the quantity between the dates given above.
If report date is 20-Sep-14 then the date range should be from what is above.
Hi doing this will only take the maximum of all..
so max(daystart) will not compute per row but will compute the total.. so max(daystart) in that set analysis will output = 19-sep-14