#1573 Ravel v27 - how create market data from this database

[TomScat]

I'm trying to construct the total capacity at a specific price.
I'm using locked data so I can look at data for one year.
Then I'm trying to sum all the quantities for all producers.
My guess would be to use running sum along the axis of marginal cost, but that does not give me any result.
What am I doing wrong here?

[TomScat]

csv database

[TomScat]

annoying interface :D
I'm including the model again.

[High Performance Coder]

"Then I'm trying to sum all the quantities for all producers" is a little ambiguous. Do you want to sum over all producers, or sum over the marginal costs for each producer?

What you are doing is performing a running sum over the producer axis, which will not give a result, since each producer has a unique value, so only those marginal costs that have a value for the first producer will have any sort of answer.

Going back to your terminology, if you replaced the running sum operator with a sum operator, and again specify producer as your axis, then effectively all those records get shifted into the one column (missing values don't contribute to the sum, but play havoc with running sum IIRC).

Using the sum operator will be equivalent to collapsing the producer handle on the ravel.

[TomScat]

That is exactly what I wanted to do.
Thanks!

I'll try to close this ticket.