I have been reading a few topics on storing data in a table and how it
is usually a bad idea. Can someone give me a clue on how to do the
following:
I am tracking Earned Value for my programs. Earned Value takes into
account the budget * % complete. Therefore it calculates how much the
manager says is done on the task by the budget. Easy enough; but then
the next month comes and I still need to know what the Earned value was
for the previous month for graphing purposes. Example follow:
January
Task % Complete Budget EarnedValue
A 20 100 20
Skip to next month
February
Task % Complete Budget EarnedValue
A 40 100 40
For graphing purposes i need to keep the EarnedValue for January as 20
and February as 40. Is this possible. The %complete changes on the
task so I can't calculate January anymore.
Is this a good time to store the value?
Thanks for your help.
Keith