Consolidate a field that is sum
I have a RTF that groups two fields and then has several fields that are set to sum.
Here is an example of what it looks like:
| CBS Code | CBS Description | Original Budget | Budget Change | Current Budget | Commitment |
|---|---|---|---|---|---|
| 01-01-01 | General | 100000 | 1000 | 101000 | 5000 |
| 100000 | 1000 | 101000 | 5000 |
The fields that are sum repeat rather than grouped. I tried to add a group for each field and the values repeat and I get this result:
| CBS Code | CBS Description | Original Budget | Budget Change | Current Budget | Commitment |
|---|---|---|---|---|---|
| 01-01-01 | General | 50000 | 0 | 50000 | 0 |
| 01-01-01 | General | 50000 | 1000 | 51000 | 5000 |
Should there be a conditional statement within the Original Budget, Budget Change, Current Budget, Commitment field to suppress the repeating rows?
0