Filter Amount Range in Cognos

[sujitgouda]

Hi,

I need to filter out Net values between 2000 and -2000 in an Active report.
How do I do that.

it gives me parsing error every time I validate the below expression.

[Sales Reporting Summary (Query)].[Transaction Details].[Transaction Type Rollup] in 'Redemption' and
[Sales Reporting Summary (Query)].[Measures].[Trade Amount YTD] between 2000 and -2000

[MFGF]

Hi,

I need to filter out Net values between 2000 and -2000 in an Active report.
How do I do that.

it gives me parsing error every time I validate the below expression.

[Sales Reporting Summary (Query)].[Transaction Details].[Transaction Type Rollup] in 'Redemption' and
[Sales Reporting Summary (Query)].[Measures].[Trade Amount YTD] between 2000 and -2000

Try

[Sales Reporting Summary (Query)].[Transaction Details].[Transaction Type Rollup] in 'Redemption' and
[Sales Reporting Summary (Query)].[Measures].[Trade Amount YTD] between -2000 and 2000

or even

[Sales Reporting Summary (Query)].[Transaction Details].[Transaction Type Rollup] in 'Redemption' and
[Sales Reporting Summary (Query)].[Measures].[Trade Amount YTD] >= -2000 and [Sales Reporting Summary (Query)].[Measures].[Trade Amount YTD] <= 2000

MF.