Forum Discussion

Nourhassan's avatar
Nourhassan
Helper I
4 years ago

Calculate Change by previous row value

Hello,   I need to calculate the load change hourly, so how the load is changed from time to time per percentage like the table below.    I have a table with a TIME (From 0 to 23) Column an...
Need Help
Tips and Tricks
Nourhassan's avatar
Nourhassan
Helper I
4 years ago

Hello, 

 

Is it possible to add this column to another table without any relationship?

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    I don't understand what you are trying to accomplish. Please elaborate.

    • Nourhassan's avatar
      Nourhassan
      Helper I
      4 years ago

      I have these two tables below:

       

       

       

      I have a Report with a new Calculation, named "Expected Demand" which multiply the "Load Change" from Table DailyLoad with "Switch_MW"  from Table ENS. Both tables are not in relationship. I don't know how to handle this. 

       

      Expected Demand (MW)
      Switch MW*Load change %

       

      The Load change in the Calculation "Expected Demand" has to be chosen from the correct timezone in Table dailyload.

       

      It is more clear now?

       

       

       

      • Nourhassan's avatar
        Nourhassan
        Helper I
        4 years ago

        The new column has to be added to ENS Table.