how to hide records in table depending on values calculated

[chriscools]

Hello,

i have a tabel graph-table where i want to hide every row where "Stock Kontich" is zero and "Mechelen genoeg" has a negative number.

What would be the best way to do this?

thanx!

chris

SkuCode	SkuNL	open   bestellingen	stock Mechelen	stock Kontich	Mechelen genoeg?
		262844	690095	14397	427251
Q201WR	Kaars wildroos   D2.2H25	2448	0	0	-2448
Q201FR	Kaars framboos   D2.2H25	2292	0	0	-2292
Q240N	Kaars 3 wieken zwart   D12cm	2142	0	0	-2142
13555	Zak van 6 veders   elastic	1873	8	0	-1865
Q214P	Kaars bol pruim D6cm	1764	12	0	-1752
Q214O	Kaars bol oranje D6cm	1632	0	0	-1632

[jvitantonio]

Hi, on each expression you need to write:

IF(SUM([stock Kontich])<>0, SUM([stock Kontich]))

And do the same for the other experssion.

I hope this help.-

[chriscools]

Hello,

this helps me in the sence that it only shows the calculation if it is not zero, but it doesn't hide the line.

i would think that i could hide it by suppresiing the null values?

and if use the calculated dimension it gives me "error in calculation" in the column of the calculated dimension.

any idea's?

chris

[jvitantonio]

Sorry I might not understand the problem, but this should help you. Check out the application attached.

[Gysbert_Wassenaar · Accepted solution]

if [Stock Kontich] and [Mechelen genoeg?] aren't fields but expressions you need to figure out how to aggregate the calculations over the other dimensions using the aggr function. See attached example.

[chriscools]

Hello,

thanx, your example helped me a lot!

i think i had to do it with the calculated dimension because i think with the other solution i could not manage if i have 4 calculated columns  and i want to exclude records based on only the null values in 2 columns.

grtz,

chris