4 Replies Latest reply: Jul 22, 2016 8:56 AM by Chris Cammers RSS

    IF

    Fabio Mazzarelli

      Hi Community


      I wish to make a kpi but the misure returns the value 0.


      Could you help me?

       

      IF ((CTRAAN = 'N' OR CTRAAN = ' '), sum({<Commessa = {'ASSTEL'}>} [TotOreLavorate]), 0)

       

      Thanks in advance

        • Re: IF
          Chris Cammers

          Does this work?

           

          sum({<CTRAAN = {'N',' '},Commessa = {'ASSTEL'}>} [TotOreLavorate])

          • Re: IF
            Mindaugas Bacius
            =sum({<
              CTRAAN = {"N",""}
              ,Commessa = {"ASSTEL"}
            >}TotOreLavoarate)
            

             

            Screenshot_3.jpg

            Set Analysis works fine. Unfortunately I couldn't manage to make the space mark in Inline load so have written CTRAAN = {"N", ""}N","."}

              • Re: IF
                Chris Cammers

                Personally I don't like to leave nulls or blanks in my table data, it tends to make selections and Set Analysis more difficult. I would recommend backfilling blanks with a word and then the nulls with something else.

                 

                You'd want to do this in your load.

                 

                The advantage to doing this is that if you see nulls in your charts then you know that you may have a relationship problem that may need to be addressed. I'm just considering missing rows in associated tables.