6 Replies Latest reply: Feb 28, 2012 4:48 AM by Iyyappan V RSS

    How to sum(amount) except null?

    Bill Ringer Salalima

      I have data sample below:

       

      Region
      Amount
      Region A5000
      Region B

      4000


      3000

       

      I want to sum up all amount excluding the Region which is NULL or no region. Now, this is simple when manipulating the table properties. But this time, I want to sum it up through set analysis... So is it possible to sum(amount) except Null Region?

       

      This is my idea, something like this: sum({<Region is not Null>} Amount)

       

      Please help me get over this, thanks. Coz I want it to display in the dashboard, and displaying data in the dashboad includes null values. Which is DUH!

       

      Thanks.

       

      Best Regards,

       

      Bill