Historical Project Status
I would like to create a historical Project Status report. Realizing that data is live I was thinking that I could possibly create child records per month that would calculate the status at the time ...
Forum Discussion
I understand that dilemma, and you can do another option, which is basically taking a snap shot of the months table each month.
I've helped people do this with inventory, when they wanted to see the historical status of their inventory. This was even done on a daily basis so they can see trends in inventory fluctuations.
This is similar for you, but you want to know the 'inventory' of projects and the phase they are in.
I've helped people do this with inventory, when they wanted to see the historical status of their inventory. This was even done on a daily basis so they can see trends in inventory fluctuations.
This is similar for you, but you want to know the 'inventory' of projects and the phase they are in.