CASE and formula completion w/calculation

[wesleycrusher]

My statement is:

round(365/rwh_model.energy_factor*
CASE
WHEN rwh_model.gas_type='propane' THEN 41045/91,333*95.500
WHEN rwh_form.energy_source='oil' THEN . 41045/138,700*149.793 END) AS EAECkbtu,

Yes, I can (and will if I have to) calculate out the portion of the formula after the "THEN" but I was wondering if there was a way to make it actually calculate it out. It will work with a single value after the "THEN" but not like it is above. Any tricks I'm missing?

Thanks.

 

[stefanwagner]

Put your calculation behind the 'end':

select 
        case 
                when nr > 2 then nr 
                when nr < 2 then (4*nr) 
        end *3  
from util 
where sign > 'h';

don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung

 

[wesleycrusher]

Great, thanks!