3 Replies Latest reply: Feb 15, 2012 6:10 AM by tdecauxt RSS

    IF in set identifier

      Hello The Community,

       

      So far, the community has answered all my question before asking, but now I'm stuck. So I hope you guys will help me

       

      Here's the thing:

      I am deseperatly trying to include an "IF" in a set identifer, but none of what I tried so far worked.

      I am trying to count the number of existing Field_2 where Field_1 = vVariable_1, but if vVariable_1 is null, then I must count all the Field_2.

      here is an example:

      = count({$< Field_1 = If( IsNull( $(vVariable_1) ),'{*}',$(vVariable_1))>} Field_2)

       

      I hope I made myself clear enough you would help me out.

       

      Thanks in advance

        • IF in set identifier
          Stefan Wühl

          Why not create a second variable (let's call it vVariableCountExp):

          =If( IsNull( $(vVariable_1) ),'"*"',$(vVariable_1))

           

          and then use vVariableCountExp in your set element:

          = count({$< Field_1 = {$(vVariableCountExp)} >} Field_2)

           

          I don't think that you can use an if-conditon in the set element directly.

           

          Stefan

          • IF in set identifier
            jagan mohan rao appala

            Hi,

             

            Can you try like this

             

            If( IsNull( $(vVariable_1) ),  count({$< Field_1 = {'*'}>} Field_2),    

                 count({$< Field_1 = {$(vVariable_1)}>} Field_2))

             

            Hope this helps you.

                

            Regards,

            Jagan.

              • IF in set identifier

                Okay that works for one.

                 

                But in fact, I have 4 différent Fields to set.

                Like Count({$<Field_1 = X1, Field_2 = X2, Field_3 = X3, Field_4 = X4>} Field_5)

                And for each one I have to select either the Value of Xn or *.

                 

                It would mean to many imbricated to many different if, to assure all possible solution.