Row Suppression

[#1]

Hi

I have created a straight table with two dimensions and 5 expressions

The dimensions are the customer name and code. The expressions work sales value etc.

My last expressions works out the difference between the exposure and the credit limit.

Some customers have obviously gone over their credit limit and show a negative value in this expression.

I need to exclude any rows that have a positive value in the final expression, basically include any customers that have gone over their credit limit. I know it is easy enough to exclude columns but not so easy with rows.

Any help would be greatly appreciated. Thanks in advance

Dave

[sunny_talwar]

Would you be able to share your app with us?

[#3]

how do I do that?

[sunny_talwar]

Check these links

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[#5]

company policy won't let me send it even if we use the scrambler...

[#6]

Hi!

Have you tried with dimension (see below)

[sunny_talwar]

Not sure what else to do... May be provide some dummy data in its raw form and explain what you want to see?

[vinieme12]

if you only want to show negative values derived from your expression then do the below

if you want to show positive values just invert to ">" greater sign.

1) Expression

     =IF( YourExpression < 0 , YourExpression)

2) On the Presentation tab check Suppress missing values

[#9]

I can't get it to work. I don't think I can reference an expression in a dimension

[#10]

unfortunately this doesn't seem to work

my expression is =if([Leeway]<0,[Leeway])

I have checked the Suppress Zero-Values and Suppress Missing and all the 0s still apppear

[sunny_talwar]

Leeway truely zero? Or is it something like 0.0000001 (a number greater than 0, but smaller than 1)? May be try this

=if(Round([Leeway]) < 0, [Leeway])

or

=if([Leeway] < 1, [Leeway])