I have got a query that shows Events and for this events there are durations. 
To get the Duration I did a calculation in my query:

```
Sum(cast(EventEndDateTime - EventStartDateTime as float)) as Duration,

```

The Table:

```
Event   Duration
[Pr     10,48
[Al     9,89
[To     1,32
[Co     0,41
[Gh     0,33

```

And I must divide each of this row with the sum of the column Duration. For Example: The Sum of the column Duration is =22,43. 
--> (10,48/22,43)\*100 = 46,72%

I tried this here:

```
Sum(cast(EventEndDateTime - EventStartDateTime as float)) / (SELECT Sum(cast(EventEndDateTime - EventStartDateTime as float)) From Event) as SumOfDuration

```

But this gave me not the correct result.
I use SSRS