if(col['产品'])=='J'
then col['销量']
else
if(col['产品'])=='J36片'
then col['销量']*1.5
else
if(col['产品'])=='D'
then col['销量']
end
end
end
---------------------
case col['产品']
when 'J' then col['销量']
when 'J36' then col['销量']*1.5
when 'D' then col['销量']
when 'D10粒' then col['销量']*2
end