thanks, that's what I'm doing but it still filters out items with no transactions. i'm using this: case when ({trandate} >= TRUNC({today} -7, 'IW') and {trandate} <= NEXT_DAY({today} -7, 'SUNDAY')) then {amount} else 0 end