Invalid RowTotal in CrossTab

Juhas

Hi, I've created crosstab, ie:

val1     |     val2     .....    Total|
--------------------------------------
21:00   |  5:00       ......   2:00

My values are in datetime format(hh:mm).
As you can see total value is 2:00, it should be(I mean, I want it to be) 26:00 though.

I know that total value starts counting from 0 when its range(24 hours) is exceeded.
How to omit that?

ctf1800

Juhas wrote: »

Hi, I've created crosstab, ie:

val1     |     val2     .....    Total|
--------------------------------------
21:00   |  5:00       ......   2:00

My values are in datetime format(hh:mm).
As you can see total value is 2:00, it should be(I mean, I want it to be) 26:00 though.

I know that total value starts counting from 0 when its range(24 hours) is exceeded.
How to omit that?

in the total text box should be something like: Sum[<val1>+<val2>]