I have to create a Budget report showing the ORIGINAL Budget Amounts” (Revision # 0001), the “Total of Budget Revisions” and then to “Revised Total Budget” for each task.
I used the following formula for the Original Budget Amount:
If {PJREVCAT.RevId} = "0001" then
{PJREVCAT.Amount}
Else 0
I have 2 problems:
1. If there are 3 tasks per Budget, it displays the 5 task amount in the Original Budget column comparing it to only one task amount for the other columns, i.e. I have now 9 (3*3) lines instead of 5 lines.
2. If there are 2 budgets revisions (”0002”,”0003”), they also show up for each task displaying 0.
I am currently getting a result per job similar to this:
Task
Original Budget
Total of Budget Revisions
Revised Total Budget
000000
2000
500
2500
101101
100
2400
101102
200
2300
-1900
0
-100
-1700
300
I appreciate your help.
Sabrina
IP Logged