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]

May be use an if statement for all your expressions

If(Column(5) < 0, Expression1)

If(Column(5) < 0, Expression2)

.

.

If(Expression5 < 0, Expression5)

[#3]

Hi Sunny,

Please excuse my ignorance. How can I reference columns in an expression.

Below is a subset of my data. I want to show all records that have a 1 in the 1or0 column

Customer	Leeway	1or0
Bunzl Retail & Healthcare Supplies	£60,000	0
Burtons Foods Ltd  (108833)	£150,000	0
Big Bear Confectionery Ltd	£35,000	0
Globe Tech BV	£27,439	0
Branston Ltd	£100,000	0
Cott Beverages Ltd	-£312,372	1
Granton Medical Ltd	£2,307	0
Honey Monster Foods Ltd.	£60,000	0
Ice Fresh Seafoods Ltd	£20,000	0
Kettle Foods Ltd	£75,076	0
Y&S Recycling	£4	0
Moy Park Ltd (Belfast)	£11,036	0
My Protein	£177,999	0
Y&S  Recycling Ltd	£1,000	0
Dunhills (Pontefract) PLC	£204,654	0
The Jordans & Ryvita Co Ltd	-£211,196	1
Plasto Sac Uk Ltd	£64,597	0
The Seafood Company Ltd.	£4	0
Clondalkin Flexible Pkg, Vaassen	£17,550	0
Web Dynamics International Ltd	£4	0
Riverside Medical Pkg Ltd	-£21,968	1
Tilda Ltd	-£61,186	1
Tata Steel UK Ltd	-£9,847	1

[Anil_Babu_Samineni]

May be use

Sum({<1or0 = {'1'}>}Leeway)

[#5]

Thanks but that doesn't seem to work. I get another column just populated with 0

[sunny_talwar]

Assuming Leeway is an expression... try this and assuming 1or0 will be 1 or 0, you can try this

Leeway expression * [1or0]

where [1or0] is the expression label and replace Leeway expression with its actual expression you were using today. The idea is to make Leeway expression = 0 when 1or0 is 0

[#7]

Hi, Dave.

Try to use condition in calculation dimension.

if([1or0] = 1, Customer).

Then, press "Suppress When Value Is Null".

If you don't have precalculated 1or0, you can calculate it in dimension.

if(aggr("Here must be expression" , Customer) = 1, Customer).

[#8]

Hi Sunny,

Leeway is an expression so done the multiplication as suggested and I know have 0 or the correct figures. How can I suppress the 0s

[sunny_talwar]

May be check 'Suppress Zero Values' on the presentation tab

[#10]

tried that and still all 0s appear