Forum Discussion
Calculating consumption column using EARLIER function
I would suggest doing this in the query editor with the following general steps :
1. start query1
2. sort by Pole and RTC columns (only if they aren't already sorted)
3. add an index column
4. add a custom column called "previndex" with the formula: [index] - 1
5. duplicate the query to query2
6. merge query1 and query2 on query1[previndex] = query2[index] and query1[Pole] = query2[Pole]
7. calculate the difference between the two [Power meter (Wm)] columns
Resolver VI would suggest doing this in the query editor with the following general steps :
1. start query1
2. sort by Pole and RTC columns (only if they aren't already sorted)
3. add an index column
4. add a custom column called "previndex" with the formula: [index] - 1
5. duplicate the query to query2
6. merge query1 and query2 on query1[previndex] = query2[index] and query1[Pole] = query2[Pole]
7. calculate the difference between the two [Power meter (Wm)] columns