Expression that ignores some selections and contains where conditions

[matthewp]

I have an expression SUM(value)

i want to also have an expression that does 2 things

ignores all list box selections except 1 box

and

contains where conditions

(SUM(value) Where category = 'abc'/SUM(TOTAL value Where category = 'abc' OR 'xyz')

and only affected by selections from the yearperiod selection box nothing else

[jyothish8807]

Hi matt,

Try like this:

sum({<category={'abc'},listbox1=,listbox2=,listbox3=>}value) /

sum({<category={'abc','xyz'},listbox1=,listbox2=,listbox3=>}total value)

listbox1, listbox2 are the listbox whose selection should not be effected.

Mention all the list box apart from yearperiod in set annalysis.

Hope it helps.

Regards

KC

[matthewp]

by listbox1 do you mean the object id e.g. LB251 or the title?

[MK_QSL · Accepted solution]

SUM({1<yearperiod  = $:: yearperiod, Category = {'abc'} >}Value)/SUM(TOTAL {1<yearperiod  = $:: yearperiod, Category = {'abc','xyz'} >}Value)

[matthewp]

i want to also have where conditions inside the expression and divide by another expression (see question)

your on the right track though

[MK_QSL]

I have edited my reply..