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,