Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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])
Hi,
Dimensión:
If(VarA_B <> 0, [GL Code], null())
VarA_B is A to B Variance expression.