topic Remove rows from table in App Development

Remove rows from table

Sat, 20 Feb 2016 16:45:06 GMT

Hello.
I have some table:

In second column I have sum(x), these values are more or less 0.
I'd like remove rows where values are less 0.

How can I do it?

Re: Remove rows from table

Gysbert_Wassenaar — Sat, 20 Feb 2016 17:32:46 GMT

Assuming you have only one dimension, in column 1, in that table and it's name is DimA then change all measures, i.e. columns 2,3,4 and 5. Change sum(x) to sum({<DimA={"=sum(x)<>0"}>}x). Add the bold part to all the expressions. If your dimension is not called DimA then replace DimA with the correct name.

Re: Remove rows from table

adriansalas — Sat, 20 Feb 2016 17:34:06 GMT

at the expresion:

=if(sum(revenue)<0, null(), sum(revenue))

and in properties table, Presentation tab, set delete when is null

Re: Remove rows from table

fonmarcelo — Tue, 23 Feb 2016 13:09:46 GMT

Do with set analysis.

Change Sum( X ) to Sum({<DimA={"=Sum( X )<>0"}>} X)

Re: Remove rows from table

Wed, 24 Feb 2016 10:27:28 GMT

For one column, I done, thanks.
How can I do, show rows where sum values in second column OR third column more 0 ?