Set Analysis - Comparing Two Fields

[shane_spencer]

I've got a Document with two tables. These both essentially compare Original Tax (AMT_TAX_TAXREP_R_src_1) against Final Tax (AMT_TAX_TAXREP_R_clo_1) - two fields in different but linked tables.

What I want to do is only show the rows where the Change TAX (i.e. the difference between these two fields) is Zero.

i.e. Those rows highlighted in Yellow:

I think the answer is in set analysis but I'm really struggling. Can anyone help?

[YoussefBelloum · Accepted solution]

Hi,

to display only rows whch is different from 0 on the change tax column, you can do this on every column of the table:

if([Original TAX]-[Final TAX]<>0, round([Original TAX]-[Final TAX],0.01))

but here even with this you will not be able to display the lines you want because of the round function.

[shane_spencer]

Thanks! That works great, though it seems almost counter-intuitive to use the results of the Expressions like that to decide what to show in the expressions.