How to write the following expression correctly ?

[suvechha_b]

How to write the expression correctly,

Eg,

I have three option in category_ of_sales : Processed, Unprocessed, Unspecified.

But, My requirement is I need to show only 'Unprocessed' and 'Unspecified' reports for a specific tab.

I tried this , but giving error.

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales<>'Processed'>} Amount)

[#2]

Try:

sum({$<TranType = {'$(vAmountType)'},[Fiscal_Year]=,[Month]=,category_of_sales-={'Processed'}>} Amount)

[sasikanth · Accepted solution]

Try this

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales={'*'}-{'Processed'}>} Amount)

[Mark_Little]

Hi

Try

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales-={'Processed'}>} Amount)

Mark

[#5]

try this

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales-={'Processed'}>} Amount)

[effinty2112]

Try:

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales-={'Processed'}>} Amount)

which will respect selections of 'Unprocessed' or 'Unspecified' in the category_of_sales field

Or:

sum({$<TranType = {$(vAmountType)},[Fiscal_Year]=,[Month]=,category_of_sales=-{'Processed'}>} Amount)

which is similar except that selections in the category_of_sales field will not be respected.

category_of_sales=-{'Processed'}

is the same as

category_of_sales={*} - {'Processed'} ie. ALL except 'Processed'.

Cheers