4 Replies Latest reply: May 17, 2012 8:43 AM by ankurgarg1

# Remove zero valued rows from Straight Table

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

• ###### Remove zero valued rows from Straight Table

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

• ###### Remove zero valued rows from Straight Table

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

• ###### Remove zero valued rows from Straight Table

Hi,

You can also create a calculated dimension as

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

Regards

Ankur

• ###### Remove zero valued rows from Straight Table

use this expression

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