Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Perhaps this?
Sum({<STATUS={'OPEN'}, [Tax Unrealized]={"<0"}, POSITION ={'A', 'B', 'C'}>}POSITION)
Thanks for your response but A, B, C are numbers. that does not seem to be right.