My problem is I have to calculate weak planning data, for example my week starts from date (06-07-2009) To (12-07-2009) date and If I select (06-07-2009) date then it should return the sum of week data between (06-07-2009) to (12-07-2009). I want last
day of the week and last day of the month from the parameter date passed.How can I achieve this?
Is the following expression correct for calculating the week’s data?
AGGREGATE(WTD(),[Measures].[Planned Qty]) - AGGREGATE(WTD(),[measures].[Quantity])/ [DimTimeCal].[Past Wrk Day]
Thanks and Regards, Franco Lopes. Ask a Question and you are fool for a second but if don't ask a question you are fool forever.
View Complete Post