add constraint on calculation

[#1]

Hi,

I have an expression in a chart: Sum(OPCODE_COUNT*SUBSCRIBER_COUNT)

I want to add set analysis that will show the calculation for a specific value of a KEY disregarding users selections.

I wrote this expression : Sum({1<KEY_ID=2>}OPCODE_COUNT*SUBSCRIBER_COUNT)

I get an error sign under the second curly brackets.

what is wrong with the expression?

Thanks,

[#2]

can you make this one in the script ?

OPCODE_COUNT*SUBSCRIBER_COUNT as total

then try this one

Sum({1<KEY_ID=2>}total)

[simondachstr]

Try:

Sum({1<KEY_ID={'2'} >}OPCODE_COUNT*SUBSCRIBER_COUNT)

[Gysbert_Wassenaar]

Close, the value you want to restrict on needs to be in curly braces too:

Sum({1<KEY_ID={2}>}OPCODE_COUNT*SUBSCRIBER_COUNT)