Forum Discussion

Nourhassan's avatar
Nourhassan
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
4 years ago

The new column has to be added to ENS Table.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      I have no expertise in using LOOKUPVALUE. I try to avoid using that function, and prefer to have a solid data model to work with.