Help With Set Analysis

[#1]

Hi Please help

why do I get an error with this syntax =AVG(IF(DASHMEASURE_SK=11,({$<MEASUREDIMENTION3=>}MEASUREDIMENSION1)))

i AM TRYING TO EXCLUDE MEASUREDIMENTION3 FROM MY SELECTIONS

[#2]

I'm not sure what you need, but it can be like this:

=AVG( {$<MEASUREDIMENTION3=, DASHMEASURE_SK={11}>} MEASUREDIMENSION1)

It means that for all current selections for ALL (regardless of current selections for MEASUREDIMENTION3) MEASUREDIMENTION3 and DASHMEASURE_SK=11derive AVG() of MEASUREDIMENSION1

[#3]

Hi Nick

Thanks for the feedback, I wish to derive the avg() of MeasureDimension1 for all current selections except MeasureDimention3

[#4]

Explain a condition for "except MeasureDimention3" then.

[#5]

MeasureDimention3 is one of the selections, I want it excluded from the calculation

[#6 · Accepted solution]

Still don't get it. You are selecting some data in MeasureDimention3 and you want to calculate all the data but for all others, that is exclusion for the MeasureDimention3 for the field itself, right?

if it's correct, then you can use this:

<pre>=AVG( {$<MEASUREDIMENTION3=e(), DASHMEASURE_SK={11}>} MEASUREDIMENSION1)

[#7]

Nick my friend you are a star, that is exactly what I needed