Sum Total

[#1]

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

[#2 · Accepted solution]

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

Thanks, JV