Hi,

The attached query gives me a sum. I would divide this result by 60, but how?

hello,

try this, please

domain tcmcs.double tempo

select
tipcs020.cprj,
tipcs021.dsca,
sum(tirou102.rutm):tempo
from
...
where
...
group by
...
selecto
tempo = tempo / 60
endselect


Olivier

In attached my new code, but there's something wrong because I obtain a syntax error:

"SELECT" expected instead of "domain"

Simply, the code is valid for script, not for easy sql.

Suggestion:
Use your original query and modify the reportfield instead.

I'm really sorry, but I do not know how do it.
Some might suggest any solution? Thanks!

i guess zardoz suggestion is to divide value in reportfield... if i understood well ;)

see attachment

Great, it works!