1 2 3 4 5 6 7 8 9 10 11 12 13
| Select cod_typ_tick as USAG
CASE WHEN dur_reel_comm is null then 0 else dur_reel_comm END AS DUREE_EM ,COUNT(*) as idnt_tick
CASE WHEN SUM(CASE WHEN USAG = '01' THEN DUREE_EM END) IS NULL THEN 0 ELSE SUM(CASE WHEN USAG = '01' THEN DUREE_EM END) END AS DUREE_EM, SUM(CASE WHEN USAG = '01' THEN IDNT_TICK END) AS NB_VX, SUM(IDNT_TICK) AS NB_TOT,
100 * ((SUM(CASE WHEN USAG = '01' THEN IDNT_TICK END)) +0.001) / ((SUM(IDNT_TICK)) +0.001) AS TX_VX
Voici ce que j'écris : avec des message d'erreurs du genre " erreur de synthaxe, operateur absent" et je tourne en rond
select cod_typ_tick as USAG
IIF( IsNull ([dur_reel_comm]) ,0,dur_reel_comm),count(*) as idnt_tick,
IIF(sum( IIF(IsNull([coll.cod_typ_tick = '01'],0,IIF(Sum([coll.cod_typ_tick = '01'],dur_reel_comm))) as DUREE-EM,
SUM(IIF([coll.cod_typ_tick]) = '01',idnt_tick) AS NB_VX,
Sum([IDNT_TICK]) AS NB_TOT,
100* ((SUM(IIFIsNull([cod_typ_tick]) = '01',IDNT_TICK)) +0.001)/Sum(IDNT_TICK +0.001) AS TX_VX |
Partager