5 Replies Latest reply: Apr 12, 2010 6:17 AM by Darius Pranskus RSS

    Set Analysis Syntax

      In my fiscal calendar table, I have a column called QtrIndex that sequentially numbers each fiscal quarter. In my expression, I would like to evaluate both current quarter and prior quarter's sales to get the overall change. However, I'm having trouble writing the expression to sum the previous quarter's sales. Can someone help with the correct expression. This didn't work and I'm not sure why:

      sum({$<QtrIndex = {$(QtrIndex-1)} >} POSAmt)