greater than and less than

[Anonymous]

I have a column of $ values- both negative(-$14.27) ,Positive($14.27) and Balanced( $0.00).

I want to do a Text Object to display the SUM of the Greater Than $0.00 and the Less Than $0.00.

I am using this expression

=sum(DIFFERENCE <'0') & (DIFFERENCE>'0')

But it is only returning the SUM of the negative(-$14.27).  If I switch the order of the Greater and Less, it then will SUM only the positive.

What would be the correct expression?

Thanks!

Dan

[Anonymous · Accepted solution]

try  this.

if(DIFFERENCE<>0,count(DIFFERENCE))

or

if(DIFFERENCE<>,fabs(Sum(DIFFERENCE)))

[Anonymous]

O well:

='Total: ' & sum(if(DIFFERENCE>0,DIFFERENCE)) - sum(if(DIFFERENCE<0,DIFFERENCE))

[Anonymous]

Thank you all for the help.

This expression worked-

='Total Bank Lock Box Differences:  ' & count(if(DIFFERENCE<>0,DIFFERENCE))

Dan