9 Replies Latest reply: Apr 10, 2018 6:23 AM by Sunny Talwar RSS

    Excluding Null Values in KPI

    satish rathod

      Hello All,

      I wanted to exclude the Null values from the KPI Chart for sales

      I have tried the following equation,

      If(Channel= Null(),0

          if(Channel='xyz',

               Sum({<condition={'bat'}>}sales),

                   if(Channel<>'xyz',

                        Sum({<condition={'ball'}>}sales))))

       

       

      output.JPG

      However I am not getting the correct result

      Total sales = 185847.

       

      So wanted to know if there are any changes to be made to the equation.

       

      Thanks in Advance.