Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have a TabDiagr showing rows of Data where one Expression gives NULL.
These values should be suppressed as they are not relevant for the Analysis.
The first three are important, showing Minus values. Thereafter the NULL values should be suppressed.
The Expression for RohE is
sum ({$<RohE={'>-2500<=-1'}>}RohE)
You can add to this condition to all the expressions except first expression
If(Column(1) = 0, 0, Second_expr)
If(Column(1) = 0, 0, Third_expr)
Column(1) - Returns value of first expression
You have values coming through from that first expression, so not sure I understand what you want to supress?
The Nulls within 'Rechnung', or the 0 Euro numbers from row 4 onwards?
Sorry Joe,
I want to suppress the lines with 0 Euro numbers from frow 4 onwards.
Tks
Wolfgang
It looks like, 'Mitarbeiter', 'Rechnung' and 'Herkunft' are expressions also? Can you share those too please?
As they are returning values, that is why row 4+ are showing. So will need to adjust them to be relative to the first expression.
You can add to this condition to all the expressions except first expression
If(Column(1) = 0, 0, Second_expr)
If(Column(1) = 0, 0, Third_expr)
Column(1) - Returns value of first expression
Hi
Expression for mitarbeiter:
If(Column(1) = 0, 0, <original expression for mitarbeiter>)
Replace the italics (including the <>) with the actual expression. Then do the same with rechnung and herkunft. Then enable suppress zero values.
HTH
Jonathan
Hi Jonathan,
thanks your correct and helpful answer!
We do have only one possibility to check: correct,
and anbu was first:-)
Thanks to all of you!
Wolfgang