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
Quote from: newb2cog on 23 Sep 2014 11:43:59 AM
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.