Totals with Set Analysis, bug or am I stupid?

[#1]

Hi all,

I've got this expression to work out Total Market Share, trying to get it to work with a total for each month in a line chart.

My expression:

sum(Value)/
          sum({<Category=,Manufacturer=,Brand=,[Pack Size]=,[Pack Type]=,Barcode=,Description,SizeDesc,Packs=>}total(<[Chart Periods]>Value))

The weird thing is at the top of the expression editor it says: "Expression OK" but in the actual expression there is a red squiggly line under the last bracket (see above)

Is my syntax wrong?

Any help would be appreciated.

Tx, Cindy

[Gysbert_Wassenaar · Accepted solution]

There shouldn't be parentheses around the <[Chart Period]> part:

sum(Value)/

          sum({<Category=,Manufacturer=,Brand=,[Pack Size]=,[Pack Type]=,Barcode=,Description,SizeDesc,Packs=>}total <[Chart Periods]>Value)

[#3]

Thank you, embarrassingly easy. Just weird how the Expression was "OK".