why CORR return NULL....
Why CORR return NULL....
I'm using the CORR () function.
select options.NAME_OPT,
(options.PER_OPT / 12) as pecr,
(count(draws.ID_DRW) / 9) as nbr,
corr(options.PER_OPT, count(draws.ID_DRW))
over(order by options.NAME_OPT) as cor
from options,
draws
where options.ID_OPT = draws.ID_OPT
and options.ID_SIT = 1
and options.PER_OPT is not null
group by options.NAME_OPT,
options.PER_OPT
But the value return is always NULL
Anyone could help me
Thanks for your help
Benoit