5 Replies Latest reply: Apr 7, 2010 7:06 PM by Les Backman RSS

    help with expression

      Please help with my expression.

      I am trying to get a sum of previous year to date sales.

      if(date([INVC DATE])=yeartodate([INVC DATE],-1),SUM([TOT AMT]), 0)

       

       

      Once i get this right I will make it a flag in my Load but for now I am testing it as an expression





      Any help is much appreciated