Hi Everyone -
Need just a little bit of help. I have a report that
calculates totals(column totals and totals across the page).
This report groups the line items by date. However, contain
in some of the fields are negative values which shows up on
my report as a double entry. for example, I have a Total column that sums various columns across the page and places the total in the total column. Whenever there's a negative value in one of the columns and the total column is negative, a double entry shows up on the report for the same date along with the negative value. How can I drop this negative value from the report?
Need just a little bit of help. I have a report that
calculates totals(column totals and totals across the page).
This report groups the line items by date. However, contain
in some of the fields are negative values which shows up on
my report as a double entry. for example, I have a Total column that sums various columns across the page and places the total in the total column. Whenever there's a negative value in one of the columns and the total column is negative, a double entry shows up on the report for the same date along with the negative value. How can I drop this negative value from the report?