Straight table hide expression value

[MikeRadem]

Hi,

I'm trying to hide rows in a straight table if the expression returns a value between -0.05 and 0.05.
Until now this seems to be impossible.

Anyone willing to accept this challenge?

Here is my table:

For dimensions it is possible to hide 0 values.

However, my column 'Afwijking' has a pretty long calculation, including Sum (so you can't make it a dimension as far as I know).

Therefore, I tried to make 'Journaalpost' empty if the value of 'Afwijking' is between -0.05 and 0.05.
If I manage to do this I can hide the empty values on this dimension.

I made the calculation of 'Afwijking' as a variable named vAfwijking.

What I tried so far (and dind't work)
1) If(not Match($(vAfwijking),'0.00','0.01','0.02'),ID_JOURNAALPOSTNR)
2) Aggr(Only({$<
($(vAfwijking))={">0"}
>}ID_JOURNAALPOSTNR),ID_JOURNAALPOSTNR)

Tried these in like 40 possible ways but can't figureout how to make it work.

Can any one please help with this?

Thnx,

Mike

[Arthur_Fong]

You have a sample app?

[Lars_Esser]

Hi Arthur, 

i'm a collegue of Mike and i have made a simple example app. 

Only the lines with a deviation > 0 are relevant. We want to hide the other lines. 

Many Thanks in advance!

Lars

[Prashant_Naik]

Hi,

this might help you,

in every measure put the expression of deviation like this,

if(deviation>0,sum(measure)) and in Add-on tab of straight table uncheck the include null or zero values checkbox.

this might hit on performance but think so you can achieve what is required.

Thanks & Regards,

Prashant

[Arthur_Fong · Accepted solution]

In Nummer dimension, click on fx and try this:

=if(aggr(fabs(round((SUM(amount)*0.19)-sum(tax),0.01)),Nummer)>0,Nummer,null())

Uncheck "Include null values".

Thanks and regards,

Arthur Fong