cancel
Showing results for 
Search instead for 
Did you mean: 

How to Exclude '' Exception Condition" in Result rows of a query Output

Former Member
0 Kudos

Hi Experts,

There is an Exception on keyfigure in a Query and I need to Exclude that Exception Condition in the result rows of the Query, But my Exception should work on Individual Rows.

Thanks

Bhanuprakash.

View Entire Topic
hai_murali_here
Advisor
Advisor
0 Kudos

Hi,

Open that Exception in QD and Edit->Display Tab->Exceptions Affects Characteristics Cells->Rows and Columns

Rgds,

Murali

Former Member
0 Kudos

Hi Murali,

The Rows and Coloumns option is not working. Still the exception is active on the result rows. Thanks For your reply.

hai_murali_here
Advisor
Advisor
0 Kudos

Hi,

Please do the following....

Open the Exception->Edit->Cell Restrictions tab->Select "Exception Affects Everything" radio button->Define Cell Restrictions->New->Select the characteristic and set the operator as "Everything Except Totals"->Click Transfer and Save the Query and run it.

This will work perfectly fine.

Rgds,

Murali

Former Member
0 Kudos

Hi Murali,

This time it is working perfectly. Thanks for your Solution.

Former Member
0 Kudos

Hello,

I have just tried the first method (tick exception affects char cells /rows and columns) and I did not succeed.

But trying the 2nd suggestion, on the cell restriction tab I cannot find anything except the 2 radio buttons (Exception affets everything & Exception only affets results), I don't know what you meant buy "new"...

Are you using 3.x??

Alice