trying to get a column that shows summed sales from last week, and i have used this formula a bunch of other times without issue. but for whatever reason it is not working this time. you see anything out of sorts?

decode(concat(to_char({trandate},'IW'), to_char({trandate},'IY')), concat(to_char(({today},'IW')-1), to_char({today},'IY')), {amount}, 0)