Forum Discussion
Historic RAG
Hi Does anyone know a simple way to collect historic RAG statuses etc. from Project Online? We want to show month on month changes to statuses however all reporting is 'live' - help!:) Thanks ...
Here is a very simple field
formula (for a custom task duration field) which gets close to what I think
you want: IIf(ProjDateValue("NA")<>[Actual
Finish],-99999,ProjDateDiff(now(),[Finish]))
As you can see this calculates a variance between Now() and the scheduled
finish date. If the task has an actual finish date, we set this value to a
large negative number.
For the indicators, compare to the value: for example:
- Less than -200 d: Blue circle
- Equal or less than 0: Red circle
- Equal or less than 7d: Yellow circle
- Greater than 7d: Green circle