1 Reply Latest reply: Oct 13, 2014 7:47 PM by Jon Vance RSS

    Sum Total

      Hi

      A little help, please.

       

      The first expression works for a cell in a column:

       

      Sum({<[4_WEEK_ROLLING_RETAIL]={"P4WTY"}>} TRX_QTY_NORM)

      (returns an integer)

       

      But when I want to get the total of ALL the values in ALL the cells in the column:

       

      sum(TOTAL ({<[4_WEEK_ROLLING_RETAIL]={"P4WTY"}>} TRX_QTY_NORM)

       

      I get Error in expression.

       

      Any idea?

       

      Thanks, JV