Filter out only rows with difference (calculated)

[#1]

Hi,

I have two columns with SET analysis which I compare. If there is any difference I set a name depending it its

lower or higher then the standard cost.

But I would like to remove all the rows which having 0 in the list only intreseted in the materials which differ.

regards mikael

[christophebrault]

Hi,

You can create a difference column in expression 1 and use fabs() function to have absolute values, hide this column in "Presentation", and use dimensional limit to filter only > 0.

[#3]

Thanks for a quick responce.

I am not sure where I could find "diminsianal limit" in my straight table ?

regards.

[christophebrault]

3rd tab in V11

[#5 · Accepted solution]

Thanks, I was in version 10