Bypass problem

[#1]

Dear All,

I want to bypass Market field but not able to bypass...

My expression is ::

If(Flag1 = 'SS',

(Sum({<[HF NAME] = {'TURNOVER'},Market1=>}[Amount])),

If(Flag1 = 'CC',

(Sum({<[HF] = {'TURNOVER'},Market1=>}[Amount in local cur.]))

- Sum({<[HF NAME]={'DEDUCTION THIRD'},Market1=>}[Amount in local cur.])

- (Sum({<[HFM NAME]={'DIRECT COST'},Market1=>}[Amount in local cur.])* -1)))

Plz tell me is there is any fault in the expression ...??

[Nicole-Smith]

Where do you have this?  Is it a dimension? Expression?  Load Script?

If it's a dimension, you need aggr() in order to use an aggregation function.

If it's in the load script, you can't use set analysis.

[Clever_Anjos]

Is your expression tab showing any errors?

[#4]

Its my expression ...and there is no error occurs but market is not bypass by this...

[Nicole-Smith]

It should be.  I don't see anything wrong with your expression.  Can you please post a sample .qvw?