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

hello lbendlin,

 

is that helpful? Or do you need it as excel file?

 

R_TIMELOAD
0795
1724
2697
3677
4667
5658
6734
7692
8707
9728
10756
11766
12764
13730
14725
15780
16779
17781
18881
19860
20838
21837
22837
23811

 

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

Thank you for providing sample data.  Something like this?

 

see attached

  • Nourhassan's avatar
    Nourhassan
    Icon for Helper I rankHelper I
    4 years ago

    I think you have made a mistake with the number to divide. The dividend should be the first number of Subtraction (Minuend).

    • Nourhassan's avatar
      Nourhassan
      Icon for Helper I rankHelper I
      4 years ago

      Also, when I put this measure in my table, then I got an empty column without error. 

      Can someone help me please? I don't know why the column is blank

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

        My proposed solution is based on the sample data you provided.  If the sample data does not cover the issue fully then please provide more descriptive sample data.

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

      I don't think so.  Value growth computations generally follow the pattern 

       

      (New Value minus Old Value) divided by Absolute of Old value