Filtering off an Expression

[ysiroong]

Hi.

I'm trying to build a filter based off an expression field.  The field shows the net amount between two other values and I want to create a filter to exclude any records that return a zero amount.

The filter needs to be dynamic as I will be using other filters to limit the data set.  The full table contains other data points so I can't use the suppress zero values option.

For example, I have the chart below

If I select a filter to reduce data in A Net, the table changes to

I want the filter to now see the 0 variance in A to B Variance and drop the record from the chart.

Does anyone know of a way to do that?

[sunny_talwar]

May be something like this

If(A to B Variance Expression <> 0, A Net Expression)

If(A to B Variance Expression <> 0, B Net Expression)

A to B Variance Expression

Or you can use a calculated dimension like this

Aggr(If(A to B Variance Expression <> 0, [GL Code]), [GL Code])

[jhoef-pv]

Hi,

Dimensión:

If(VarA_B <> 0, [GL Code], null())

VarA_B is A to B Variance expression.