Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this.
if(DIFFERENCE<>0,count(DIFFERENCE))
or
if(DIFFERENCE<>,fabs(Sum(DIFFERENCE)))
O well:
='Total: ' & sum(if(DIFFERENCE>0,DIFFERENCE)) - sum(if(DIFFERENCE<0,DIFFERENCE))
Thank you all for the help.
This expression worked-
='Total Bank Lock Box Differences: ' & count(if(DIFFERENCE<>0,DIFFERENCE))
Dan