Set analysis error - too many filters ?

[#1]

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

[jagan]

Hi,

In set analysis you should not specify separately for different values i.e,

Instead of this

EMP_SERVICE={'EA1'}, EMP_SERVICE={'EA2'},EMP_SERVICE={'EA3'},EMP_SERVICE={'EA4'}

Give EMP_SERVICE={'EA1', 'EA2', 'EA3', 'EA4'}

Hope this helps you.

Regards,

Jagan.

[jagan · Accepted solution]

Hi,

You can just use this simple expression instead of your expression

=sum({$<FAMILLE_TACHES={"BO Sinistre","FO Sinistre","Ouverture Sinistre", "Formation","Management", "Demande Interne","Direction","Projet", "Suivi Sinistre" },

EMP_SERVICE={'EA1','EA2','EA3','EA4'}>}TEMPS_DUREE)

Regards,

Jagan.

[#4]

It's perfect !

Thanks a lot Jagan Mohan 🙂 🙂

[#5]

I think I want to complicate my life! It is true that it is much easier like that!

Thanks again.

Emmanuelle