Hello,

I am trying to calculate the total amount between periods using date parameters. I am using a LOD expression, but I can't figure out how to get it to work with the dates factored in as well as the counterparty. I need to calculate a weighted average by period so I need the 'Tot Amt' column to only sum the current year selected in the date parameter. I think I need to be using a table calculation instead of a LOD, but I am not sure how.

Please help.. I attached a sample workbook.

IF DATEPART('year',[Filtered Date]) >=DATEPART('year',[Start Date])  AND  DATEPART('year',[Filtered Date]) <=DATEPART('year',[End Date])

THEN  { FIXED [Counterparty],DATEPART('year', [Filtered Date]): SUM([Amount]) } END

When I add, the DATEPART to the LOD - it creates different sums by year. I want it to sum for the entire period.

Thanks!