No solution yet, but some more food for thought…
If I had just one beginning and one end, then this would work perfectly, or this approach where there is a boolean field (called ComprON) and then grouping on ComprON. However, since there are 12 period beginnings and 12 period endings every year (representing our 12 bills received), and I plan to store several years’ worth of data, I do not think the above approaches make sense. I should also note that there is a rate per kWh that applies to each period, and this too changes. However, that should be easy enough to store in a new field called “kWh_rate” or whatever.
