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

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

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