set analysis with the reference columns

[alexpanjhc]

Hi

I am trying to use a reference column in my set analysis and I am not sure how it works.

Sum({<STATUS={'OPEN'}, [Tax Unrealized]={"<0"}>}POSITION)

where Tax Unrealized is calculated by other fields let's say A-B-C.

I want to sum up the position by all the lines where A-B-C<0 and it is showing me everything including A-B-C>=0.

Where am I wrong?

thanks!

[saminea_ANZ]

Perhaps this?

Sum({<STATUS={'OPEN'}, [Tax Unrealized]={"<0"}, POSITION ={'A', 'B', 'C'}>}POSITION)

[alexpanjhc]

Thanks for your response but A, B, C are  numbers. that does not seem to be right.