0

Some idea please

In this table I calculate all Earned Value KPI's for every CutOffDate (all Fridays).

The next Friday 17/May the new values are calculate, but lost the past.

Is there a way to generate a new table with these value for each Data|Date

10/May - and all values 

17/May all next value

Until the last scheduled date

4 replies

null
    • Fred
    • 7 mths ago
    • Reported - view

    can you post a sample DB?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 7 mths ago
      • Reported - view

      On Project Table I have a subtable name KPI Data.

      On the Settings Project I have the Table Data|Date where I run the script.

      X-LUSTTER HB1 New.ninox
    • Fred
    • 7 mths ago
    • Reported - view

    I was just thinking that you do a lot based on your cut off date. Why not put all of your data tables that use this as subtables to the cut off date table? So you would have KPI as a subtable of cutoff. Then in KPI you can put your formulas that go through cutoff to get the data for KPI.

    So when you create a cutoff record, then you create a KPI record (and all other subtables), then [BAM] all of your data will just magically appear.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 7 mths ago
      • Reported - view

      uppsss ok let me work on that idea

      Thanks

Login to reply

Content aside

  • 7 mths agoLast active
  • 4Replies
  • 54Views
  • 2 Following