Sum Total

Mon, 13 Oct 2014 22:38:13 GMT

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

Re: Sum Total

Mon, 13 Oct 2014 23:47:35 GMT

Re-copied and it worked. I think something was invisible that got fixed when I chose from the auto-populate.

Thanks, JV