Set Analysis with multiple conditions

[benoitgochel]

Hi All,

I have a set analysis to make in order to exclude fields in a table.

I want to keep only the lines from the subProjectGroup "P3" with a status "In Process" or "En cours".

Here is my formula :

Num(Sum({<[Proj.SousGroupeProjet]={"P3"}>}{<[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')

When I put

Num(Sum({<[Proj.SousGroupeProjet]={"P3"}>}[#Hours.QTY]), '$(vNumFormat)')

it works fine... same for

Num(Sum({<[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')

But when I put both conditions, only the 'Proj.ProjectStatus' one is taken.

What can I do to solve this?

Thank you in advance.

Best regards

[shraddha_g]

Try

Num(Sum({<[Proj.SousGroupeProjet]={"P3"}>} * {<[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')

[kaushiknsolanki · Accepted solution]

Try this.

Num(Sum({<[Proj.SousGroupeProjet]={"P3"},[Proj.ProjectStatus]={"En cours","In Process"}>}[#Hours.QTY]), '$(vNumFormat)')

Regards,

Kaushik Solanki

[benoitgochel]

It worked. 🙂

Thank you very much.