Forum Discussion
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 and Load value. Based on that i need to calculate the change in percentage. The Load Change in Time 0 should be here empty like shown in the above screenshot. The load change in Time 1:00 was calculated here as follows: [(1963.935 - 1986.167) / 1963.935].
Thank you in advance.
23 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with.
Nourhassanhello 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
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
To know to which date the data is from. Maybe, later the dataset will be extended with other dates too. Then I can compare both dates with each other.
- lbendlin
I added the date column. Not sure what added value it provides. See attached.
- Nourhassan
Thank you for your help. I really dont know what the problem is. This is my table below:
- Nourhassan
Hello,
Is it possible to add this column to another table without any relationship?
- lbendlin
I don't understand what you are trying to accomplish. Please elaborate.
- Nourhassan
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?
