Display value straight table

[emteam162]

Hi,

I have straight table as

Dim1	Dim2	Expression1	Expression2
a	z	12%	56%
b	w	-40%	2%
c	x	33%	-45%
d	y	17%	-17%
e	m	-	60%

I want to display only rows red

the role are if (Exp1 <-30% or Exp2 <-30% then display value of each column)

how can i do that wiht nprinting

Many thanks for your help

Said

[jonathandienst]

Expression 1

=If(...expression 1... < -30 Or ... expression 2... < -30, ...expression 1...)

Expression 2

=If(...expression 1... < -30 Or ... expression 2... < -30, ...expression 2...)

Substitute your actual expressions into the above

[jonathandienst · Accepted solution]

Or as long as you are using a straight table, create expression1 and expression2 normally Then create two more expressions:

=If(Column(1) < -30 Or Column(2) < -30, Column(1))

=If(Column(1) < -30 Or Column(2) < -30, Column(2))

and hide expression 1 and 2 in the presentation tab. This has the advantage that each expression is only evaluated once.

[emteam162]

Hi,

Its work

many thanks

Said