I have created a report using the method outlined here: http://www.scriptcase.net/forum/showthread.php?2329-Nice-lookin-reports
However I cant seem to add 2 fields together and then subtract one from the total.
($F{Column2} + $F{Column4}) - $F{Column6}
The above works fine when a number is present (other than 0). However if Column2 is 100 and Column4 is 0, it appends the 0 at the end and makes their total 1000.
Also is it possible to hide the rows where the sum of the 3 fields equals 0, without displaying this sum?
Any help would mean a lot.
Thanks