Remove zero valued rows from Straight Table

[#1]

Hello,

I've been trying to remove zero valued rows from Straight Table, file attached, rows coloured in Red but unable to do so.

The format of the sum(Sales) & sum(Others) is Decimal Precision=2

Search in other discussions hasn't helped.

Any help

Regards

[swuehl · Accepted solution]

The supress zero values option in presentation tab will only work as expected if all expressions return zero.

I understood that you want to suppress based on sum(Sales) (see for example row 2490).

So you can first change your first expression to

=if(fabs(sum(Sales) )>=0.01,sum(Sales),0)

to force QV to consider very small values as zero values.

Then your second expression could look like

=if(column(1),sum(Other),0)

and the last expression like

=if(column(1),column(1)/column(2),0)

Check suppress zero values in presentation tab.

Hope this helps,

Stefan

[#3]

Hi,

It helped tremendously

the best thing to know is :

The supress zero values option in presentation tab will only work as expected if all expressions return zero."

very informative indeed

Many Thanks

Regards

[#4]

Hi,

You can also create a calculated dimension as

=if(fabs(sum(Sales) )>=0.01,Dim)

Regards

Ankur

[#5]

use this expression

if(fabs(aggr(sum(Sales),Dim))>=0.01,Dim)