Forum Discussion
Nourhassan
Helper I
Helper ICalculate 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...
NourhassanHelper I
Helper Ihello lbendlin,
is that helpful? Or do you need it as excel file?
| R_TIME | LOAD |
| 0 | 795 |
| 1 | 724 |
| 2 | 697 |
| 3 | 677 |
| 4 | 667 |
| 5 | 658 |
| 6 | 734 |
| 7 | 692 |
| 8 | 707 |
| 9 | 728 |
| 10 | 756 |
| 11 | 766 |
| 12 | 764 |
| 13 | 730 |
| 14 | 725 |
| 15 | 780 |
| 16 | 779 |
| 17 | 781 |
| 18 | 881 |
| 19 | 860 |
| 20 | 838 |
| 21 | 837 |
| 22 | 837 |
| 23 | 811 |
- lbendlin
Super User
Thank you for providing sample data. Something like this?
see attached
- Nourhassan
I think you have made a mistake with the number to divide. The dividend should be the first number of Subtraction (Minuend).
- Nourhassan
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
