IF Statement

[danielnevitt]

Hi,

I would appreciate some help with a simple question, that I am struggling to fix.

I have a straight table with two calculations in column(1) and column(2).  I would like to only show records where column(1)-column(2)=0

Regards,

Daniel

[tresesco]

Modify your col1 and col2 expression to something like:

Col1 Exp:

If(column(1)-column(2)=0, <Existing Expression1> , 0)

Col2 Exp:

If(column(1)-column(2)=0, <Existing Expression2> , 0)

Then with default zero value suppression setting, you should get what you want

[danielnevitt]

Thank you for your quick response.

I have included existing expression 1 (below), however I get an error.  Do you know what the issue might be?

If(column(1)-column(2)=0, Count({<Side={'Buy'}>}Symbol , 0)

Regards,

Daniel

[tresesco · Accepted solution]

Missing a brace :

If(column(1)-column(2)=0, Count({<Side={'Buy'}>}Symbol) , 0)