Hi,
My report has a few columns that look like this:
A B > <
300 220 0 80
260 280 80 60
I cannot format the > and < columns so that they either contain zero OR the difference between the two, depending upon which column, > or < is greater.
Meaning, the first record is ok, but in the second record I want to see a 20 in the > column (80-60) and a 0 in the < column.
I can make a control in the report that will do what I want, but the problem is that I have had great difficulty making that value sum for the group it is in. Please advise.
My report has a few columns that look like this:
A B > <
300 220 0 80
260 280 80 60
I cannot format the > and < columns so that they either contain zero OR the difference between the two, depending upon which column, > or < is greater.
Meaning, the first record is ok, but in the second record I want to see a 20 in the > column (80-60) and a 0 in the < column.
I can make a control in the report that will do what I want, but the problem is that I have had great difficulty making that value sum for the group it is in. Please advise.