3 Replies Latest reply: Nov 14, 2017 6:04 AM by Benoît Gochel RSS

    Set Analysis with multiple conditions

    Benoît Gochel

      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