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 A5000
      Region B




      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!




      Best Regards,