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
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.

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Either you find a relationship (a column that matches between the tables) or you use LOOKUPVALUE() if a relationship cannot be determined.

      • Nourhassan's avatar
        Nourhassan
        Helper I
        4 years ago

        I don't have any column that can build a relationship between the tables, so I need to use LOOKUPVALUE(). Can you help me with how to use it in this case?