Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
Hi,
Its work
many thanks
Said