Suppress NULL in a TabDiagr with Set Analysis

[Anonymous]

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)

[#2]

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?

[Anonymous]

Sorry Joe,

I want to suppress the lines with 0 Euro numbers from frow 4 onwards.

Tks

Wolfgang

[#4]

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.

[anbu1984 · Accepted solution]

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

[jonathandienst]

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

[Anonymous]

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