Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thank you, embarrassingly easy. Just weird how the Expression was "OK".