missprogrammer
Programmer
If anyone can help please reply. I have financial report and every where that there is a zero they want "-" to be showninstead. now the problem is that i also have a subreport. at the end i want to do a grand total sum from the totals. but the problem is that
- 2 3
- 1 -
total - 3 3
1 2 -
1 1 -
total 2 3 -
grand total - 6 -
where i'm trying to add a number to "-" its returning "-"
how can i preform a calcultion if one of the field values is a "-" and the other is a number. Can set the "-" equal to zero, what .My database is almost compelet with this exception. please response.
- 2 3
- 1 -
total - 3 3
1 2 -
1 1 -
total 2 3 -
grand total - 6 -
where i'm trying to add a number to "-" its returning "-"
how can i preform a calcultion if one of the field values is a "-" and the other is a number. Can set the "-" equal to zero, what .My database is almost compelet with this exception. please response.