topic Re: Set Analysis with multiple conditions in App Development

Set Analysis with multiple conditions

benoitgochel — Tue, 14 Nov 2017 10:47:18 GMT

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 — Tue, 14 Nov 2017 10:58:10 GMT

Try

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

kaushiknsolanki — Tue, 14 Nov 2017 11:02:44 GMT

Try this.

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

Regards,

Kaushik Solanki

benoitgochel — Tue, 14 Nov 2017 11:04:40 GMT

It worked. 🙂

Thank you very much.