Combine variable

[husnafezaahmad]

Hello there,

I have this problem. I tried to combine these two variables, marginal cost coal and marginal cost gas.

Presentation4.png (32.77 KiB) Viewed 1395 times

I want the output for "combine marginal cost" to be like this;

Presentation3.png (122.74 KiB) Viewed 1397 times

I tried using the;

combine marginal cost = IF THEN ELSE( marginal cost gas[gas unit]<0 , IF THEN ELSE( marginal cost gas[gas unit] <0 , marginal cost coal[coal unit]:AND:marginal cost gas[gas unit] , 0 ), 0 )

but it didn't give me the output that i want. This thing has been bothering me for a week
I really hope anyone can help me on this.

Thanks in advance!

[Administrator]

I see now what you want (I think).

You would need to combine the subscript ranges into a single one. See the attached model.

[husnafezaahmad]

I see now what you want (I think).

You would need to combine the subscript ranges into a single one. See the attached model.

Oh my goodness!
Thank you so so much! Finally i got the answer on how to do that.

I owe you big time, Admin!<3