Restrict view in Straight Table

[#1]

Morning All,

I have created a rec in a straight table. However, I only want to see rows where I have values (ie non null and non zero) for both my data sources. eg in the following:

ID	BalanceA	BalanceB	Diff
1	101	100	1
2	0	25	-25
3	51	0	51
4	142	122	20

I only want to see rows 1 and 4.

Can I do this in a Straight Table?

TIA

Tony

[#2 · Accepted solution]

I missed that BalanceA & BalanceB was expression.

You have to do like this

=

if(BalanceA<> 0 and BalanceB<> 0,ID)

and

mark Supress when value is NULL.

then you get this

Anders

=if(BalanceA<> 0 and BalanceB<> 0,ID)	sum(BalanceA)	sum(BalanceB)	sum(BalanceA) - sum(BalanceB)
	243	222	21
1	101	100	1
4	142	122	20

[#3]

Thanks Ansch, that's looking good.

BTW do you know how to re-name a calculated dimension?

cheers,

Tony

[#4]

Hi Tony

In the field just over the advanced-buttom you can re-name the field.

Anders

[#5]

Got it. Thanks Anders.