4 Replies Latest reply: Jan 10, 2014 4:16 AM by EMMANUELLE DAYOU RSS

    Set analysis error - too many filters ?

    EMMANUELLE DAYOU

      Hello everyone,

      I want to display in a table, my 4 teams (EA1, EA2, EA3, EA4) for combinations of specific tasks.

       

      I get an error (syntax I guess) because only my team 4 (EA4) is displayed as a result. Does anyone have an idea?

      below my formula :

      =sum({$<FAMILLE_TACHES={"BO Sinistre"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)
      +sum({$<FAMILLE_TACHES={"FO Sinistre"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)
      +sum({$<FAMILLE_TACHES={"Ouverture Sinistre"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)
      +sum({$<FAMILLE_TACHES={"Formation"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)
      +sum({$<FAMILLE_TACHES={"Management"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)
      +sum({$<FAMILLE_TACHES={"Demande Interne"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)
      +sum({$<FAMILLE_TACHES={"Direction"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)
      +sum({$<FAMILLE_TACHES={"Projet"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)
      +sum({$<FAMILLE_TACHES={"Suivi Sinistre"}, EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}>}TEMPS_DUREE)

       

       

      The result is an image attachment.

      Thank you in advance

       

      Emmanuelle