<@U4Q5LRGH2> Maybe an out of place parenthesis, tr...
# suiteanalyticsj
jcribb
03/02/2018, 5:43 PM@candrews Maybe an out of place parenthesis, try:
decode(concat(to_char({trandate},'IW'), to_char({trandate},'IY')), concat((to_char({today},'IW')-1), to_char({today},'IY')), {amount}, 0)