Hi
I have list with room cooling load for each hour for n-number of rooms. I want to find a way to sum all sub-list at index 0’s, 1’s etc…so at the end we have only one list 0…8759 hours with sums of cooling load from individual rooms at this specific hour. In first sub-list when there is no cooling load there is value -1 so I am replacing -1 with zero to avoid subtracting. I want to find then peak value from list and its index which is peak hour when I add +1. Thanks for help
Have you tried Math.Sum and List.MaximumItem with longest lacing?
You might have to Transpose your list, i’m not sure what you meant by
I want to find a way to sum all sub-list at index 0’s, 1’s etc.
I do not want to sum as this will sum all sub list and I will have wrong sum.
I need to pick up index one from first sublist, second sublist etc
then pick up index two from first sublist, second sublist etc
I guess this graph explain this better…
