Hi, how can I group by a calculated column? I am trying to do what is below and it is not working.

select

case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'

when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'

when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'

when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'

when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'

when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'

when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'

when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'

when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'

when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'

when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'

else 'ELSE'

end as IvRange

, Profit

from Trades

group by IvRange

select

case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'

when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'

when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'

when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'

when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'

when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'

when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'

when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'

when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'

when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'

when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'

else 'ELSE'

end as IvRange

, Profit

from Trades

group by IvRange

Do more with

EXPERT OFFICE^{®} is a registered trademark of EXPERTS EXCHANGE^{®}

```
select
case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'
when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'
when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'
when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'
when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'
when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'
when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'
when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'
when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'
when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'
when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'
else 'ELSE'
end as IvRange
, Profit
from Trades
group by case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'
when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'
when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'
when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'
when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'
when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'
when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'
when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'
when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'
when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'
when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'
else 'ELSE'
end
```

but you can try:

--------------------

select

a.*

FROM

(

select

case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'

when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'

when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'

when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'

when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'

when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'

when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'

when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'

when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'

when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'

when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'

else 'ELSE'

end as IvRange

, Profit

from Trades) a

group by IvRange

```
select
a.IvRange, sum(Profit) as Profit
FROM
(
select
case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'
when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'
when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'
when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'
when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'
when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'
when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'
when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'
when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'
when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'
when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'
else 'ELSE'
end as IvRange
, Profit
from Trades) a
group by IvRange
```

## Premium Content

You need an Expert Office subscription to comment.Start Free Trial